SQL fetch value

SQL fetch value

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

View Answers

April 11, 2012 at 12:55 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.









Related Tutorials/Questions & Answers:
SQL fetch value
SQL fetch value  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
PHP SQL Fetch
PHP SQL Fetch       PHP SQL Fetch is used to fetch the records from Mysql database to PHP..._TO_REPLACE_1 The Tutorial illustrate an example from PHP SQL Fetch. To understand
Advertisements
CONVERT VALUE MONEY TO WORDS IN SQL?
CONVERT VALUE MONEY TO WORDS IN SQL?  i want to covert money or varchar value (like 7500000 ) in words like (75 lacs) then how to convert this value in this words . please give me solution
Struts2 and Hibernate Fetch Data Base Value
me what should i do for fetch the database value and shown on jsp page...") public > List<AdminProvideLeave>fetch1()// for > fetch the value from...Struts2 and Hibernate Fetch Data Base Value  Hello Sir, I am
Struts2 and Hibernate Fetch Data Base Value
me what should i do for fetch the database value and shown on jsp page...") public > List<AdminProvideLeave>fetch1()// for > fetch the value from...Struts2 and Hibernate Fetch Data Base Value  Hello Sir, I am
Data fetch from multiple SQL tables - Hibernate
Data fetch from multiple SQL tables   I am in the process of writing my first hibernate application. I have a sql query that fetches data from... access code into Hibernate code. The tables in SQL are not related using foreign
PHP SQL Rows
PHP SQL Rows       PHP SQL Rows is used to fetch the select the row value based on the condition... the value of mysql_fetch_row ( ) function which accept the parameter result. Finally
SQL add column default value
SQL add column default value       Add a Column default value is used in SQL, When create statement Query is performed in SQL .Usually, the default value is given
Close Cursors in SQL
Close Cursors in SQL      ... it is not required. A cursor in a SQL can be closed with close... The Tutorial illustrates an example 'Close Cursor in SQL'. To grasp
How to pass the value of Selected Value of combo box into sql ??
How to pass the value of Selected Value of combo box into sql ??  My SQL Database Name is MHS, user=root, password=admin,table name is sub_comb(regno,sname,sgen). Now i want to select one "regno" from Combobox and then after
how to know which jList is selected and according to that fetch the value
how to know which jList is selected and according to that fetch the value ... , jList4) in 4 different tabs in frame. Each List has the value of employee_id... is selected so that i get the value of employee_id from the correct jList (i.e which
SQL add column default value
SQL add column default value       Add a Column default value is used in SQL, When create statement Query is performed in SQL .Usually, the default value
How to add value from sql server in dropdownlist
How to add value from sql server in dropdownlist  I have created a hospital management project using jsp servlet, where one form name is patient registration, in that form i have taken id, name, and i want to retrieve a patient
SQL Alter Column Default Value
SQL Alter Column Default Value       Alter Column Default Value in  SQL Server is used with Create Table Statement. The default value will be set as per specified
Fetch Records from SQL database and convert into XML file
Fetch Records from SQL database and convert into XML file  Hi Experts... provide me the code to FULFIL my requirement.... 1) Fetch all the records from a SQL VIEW (not from original table) based on the query "SELECT * from AMAR
fetch database value to text box based on selected value my code given below pls correct my code
fetch database value to text box based on selected value my code given below...="destination" onchange="getPrice()"> <html:option value="0">...;<input type="text" value =" " property= "amount" id='pricecheck'/> <
fetch database value to text box based on selected value my code given below pls correct my code
fetch database value to text box based on selected value my code given below...="destination" onchange="getPrice()"> <html:option value="0">...;<input type="text" value =" " property= "amount" id='pricecheck'/>
Finding MAX value from emp_id column using SQL query?
Finding MAX value from emp_id column using SQL query?  I need to select maximum of the Emp_id values from SQL server 2005 table.I was using... please tell me SQL query for finding max value in Emp id column.Thanx. MY sql
use struts 1.0 to view sql table value on JSP page
use struts 1.0 to view sql table value on JSP page  Here i am using struts 1.0 to view my sql table values on jsp page. But the problem is when i append the value in bean then i find the last row of table is shown repetedly. Any
use struts 1.0 to view sql table value on JSP page
use struts 1.0 to view sql table value on JSP page  Here i am using struts 1.0 to view my sql table values on jsp page. But the problem is when i append the value in bean then i find the last row of table is shown repetedly. Any
SQL Alter Column Default Value
SQL Alter Column Default Value       Alter Column Default Value in  SQL Server is used with Create Table Statement. The default value will be set as per
SQL Out Parameter
); Fetch Value Select @y... SQL Out Parameter       SQL Out Parameter allows the stored procedure to the pass data
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
Php Sql Null
Php Sql Null This example illustrates to describe about null value of execution of sql query in php.  In this example we select data from database table which is not null. We have seen SQL SELECT command along with WHERE clause
PHP SQL Random
PHP SQL Random       The PHP SQL Random is used to fetch data randomly from database in PHP. The Rand ( ) clause is used to fetch the random data from table into the browser. 
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
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.
value is inserted into the sql table through jsp-jdbc but not getting stored into the data base,only row is increasing.  <html> <...="Submit" value="Submit"></td> </tr> </table>
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
PHP SQL Query
and fetch the data. This interaction is made executing Sql queries. To understand... PHP SQL Query       This example illustrates how to create and execute the sql query in php
SQL
SQL  hii What is sql?   hello,ADS_TO_REPLACE_1 SQL, which stands for Structured Query Language, is a special-purpose language used to define, access, and manipulate data. SQL is non procedural, meaning
SQL Average
value of the marks records from table stu. The Group by keyword in SQL... SQL Average       SQL Average, the part of Aggregate Function. SQL Average is used
PHP SQL Update
any field value of any MySQL table in PHP. Syntax: The SQL syntax of UPDATE... PHP SQL Update       PHP SQL Update is used to execute the mysql _update () function that modify
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  . Given two tables: table1(player, groundname, numcenturies); table2(ground_name, country); Write and SQL query for the following: " Select all the players from table1 who has
SQL IN Parameters
); Fetch variable valueADS_TO_REPLACE_4 Fetch Variable (@value... SQL IN Parameters       A parameter is a placeholder that accept a user-defined value, whenever
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
JDBC Fetch
JDBC Fetch       The Tutorial describe you a code that fetch the elements from a database. In this Tutorial we want to describe you an example from Jdbc Fetch. In this program code
sql
sql  i want that whenever i click add button in my form value of an column employee-id will automatically increase by one..and show the new employee-id value in text box. please send me the source code for this .   
SQL Mode
SQL Mode       SQL Mode is a Function that returns the frequent occurring value of a numeric... the following query that include a set of string value in a normal  mode. The Query
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  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 Out Parameter
call abc(@y); Fetch Value Select @y... SQL Out Parameter       SQL Out Parameter allows the stored procedure to the pass data value 
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
fetch url in php - PHP
fetch url in php  How to Fetch URL in PHP
SQL Aggregate Max
SQL Aggregate Max       SQL Aggregate Max is used to find the highest value of the column... illustrate an example from SQL Aggregate Max. In this Example we create a table
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

Ads