SQL

Home Answers Viewqa SQL SQL

QuestionAsk Questions?

sunil Kumar Verma

SQL
1 Answer(s) a year and a month ago
Posted in : SQL

how to get ( 15 march 2011) and (15/03/2011) output using SQL

View Answers

April 11, 2012 at 1:35 PM

Use the following queries to get the data from database in the given format.

For (15 march 2011) format:

SELECT DATE_FORMAT(dob, '%d %M %Y') FROM patient;

For (15/03/2011) format:

SELECT DATE_FORMAT(dob, '%d/%m/%Y') FROM patient;

where patient is our table name and dob is a field of date type.

sql
difference between sql and oracle what is the difference between sql and oracle

sql
sql how to get first row in sql with using where condition in sql? how to get last row in sql with using where condition in sql

sql
sql I want interview sql questions Please visit the following link: SQL Tutorials

Sql
Sql how to find maximum of a101,a102,a103 from a table in sql

SQL
SQL hii What is sql? hello, SQL, which stands for Structured Query Language, is a special-purpose language used to define, access, and manipulate data. SQL is non procedural, meaning that it describes

sql
sql returning value from a store procedure in sql with example Please visit the following links: http://www.roseindia.net/mysql/mysql5/stored-procedures-and-functions.shtml http://www.roseindia.net/sql/create

SQL
SQL In my computer i have microsoft sql 2008.how can i set that in the cmd.i want to use that in cmd.what is the default username and password

SQL
SQL 1)How to Store 1000 records in Oracle object. 2)Write a query for calculate highest, 3rd Highest & 10th highest salary from emp teble. 3)What is Sequence. 4)How to use rowid in Sql. 5)What is Views. 6)How

SQL
SQL how to get ( 15 march 2011) and (15/03/2011) output using SQL Use the following queries to get the data from database in the given format. For (15 march 2011) format: SELECT DATE_FORMAT(dob, '%d %M %Y') FROM

SQL
SQL Trigger query Why we use the Trigger and what it's uses? A database trigger is procedural code that is automatically executed..., user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
tables EMP, and DEPT, the structure for which are given above. Write SQL queries

SQL
events, user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
, user events, and SQL statements to subscribing applications 10)Restrict DML

SQL
events, and SQL statements to subscribing applications 10)Restrict DML

SQL

sql

SQL

sql

SQL

sql - SQL
order by SQL Query What is order by in SQL and when this query is used in SQL?Thanks! Hi,In case of mysql you can user following query.Select salary from salary_table order by salary desc limit 3,1Thanks

sql - SQL
want query? 4.what is the diffrence between sql and plsql? Hi Friend... HAVING n>1; Difference between SQL and PL/SQL: SQL is a structured query...(select,insert,update etc.), manipulate objects(DDL) and data(DML). PL/SQL

sql - SQL
sql write a dyamic sql program to display the name of a employee whose salary is <5000 Hi Friend, Use the following query... the following link: http://www.roseindia.net/sql/ Thanks

SQL - SQL
SQL Jus c da case we hve certain images in some folder or some area in sql can we create trigger or procedure so dat in front like in asp page while clicking image it will be showed in page ...... ...I mean writing code for each

SQL - SQL
SQL How to combine 'LIKE' and 'IN' operators in sql query? select name from tab1 where name like 'R%' AND city in('bangalore','mumbai'); Table Name: tab1 FieldName ===================== | name | city

sql - SQL
sql functions with examples I need sql functions with examples to learn fast. Hi friend,<%@ page language="java" import...("SQL statement is not executed!"); } } catch (Exception e

sql - SQL

SQL - SQL

sql - SQL

SQL - SQL

sql server - SQL
sql server what is SQL server? & what is oracle? are they same

sql server - SQL
sql server How many no of tables can be joined in same sql server

SQL help - SQL
SQL help Hi Deepak, Can u pls tell me what is the difference between PL/SQL and MYSQL? Is there any difference in generating the code

SQL JOINS - SQL
SQL JOINS Hom many Joins In Sql?plz explian all those things? Hi Friend, Please visit the following link: http://www.roseindia.net/sql/sqljoin/index.shtml Hope that it will be helpful for you. Thanks

learn sql - SQL
learn sql how to learn sql......idont know anything about programming knowledge Hi Friend, Please visit the following link: http://www.roseindia.net/sql/ Thanks

sql 2000 - SQL
sql 2000 why binary data when inserted into the sql column of data type image or binary is stored in the form of hexadecimal nos. instead of the name of the file inserted????? Thanx for ur response in advance

An SQL Locator.
An SQL Locator. What is an SQL Locator

sql component
sql component is sql package is the component of jdbc

auto sql script - SQL
auto sql script Is there a way of generating inserts scripts using the table structure for oracle database

SQL injunctions - SQL
SQL injunctions Could you please tell me how to handle the sql injunctions? Hi friend, SQL injection is a technique that exploits.... Prevention against SQL injection, User input must not directly be embedded in SQL

Ask Questions?

If you are facing any programming issue, such as compilation errors or not able to find the code you are looking for.

Ask your questions, our development team will try to give answers to your questions.

Tutorial Topics