Latest Tutorials| Questions and Answers|Ask Questions?|Site Map



Home Answers Viewqa SQL SQL fetch value

Have Programming Question? Ask it here!
 
 
 


sunil Kumar Verma
SQL fetch value
1 Answer(s)      2 years and 4 months ago
Posted in : SQL


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


Advertisement
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... The Tutorial illustrate an example from PHP SQL Fetch. To understand and grasp
Advertisements
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
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
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
Close Cursors in SQL
Close Cursors in SQL      ... it is not required. A cursor in a SQL can be closed with close... illustrates an example 'Close Cursor in SQL'. To grasp this example, we
PHP SQL Rows
PHP SQL Rows       PHP SQL Rows is used to fetch the select the row value based on the condition.... The row variable assigned the value of mysql_fetch_row ( ) function which accept
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
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'/> <
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
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
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
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 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
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
fetch url in php - PHP
fetch url in php  How to Fetch URL in PHP
PHP SQL Random
PHP SQL Random       The PHP SQL Random is used to fetch data randomly from database in PHP. The Rand... of sql_random.php This example show you to fetch random data from database table
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
mysql_fetch_object and mysql_fetch_array.
mysql_fetch_object and mysql_fetch_array.  What is the difference between mysqlfetchobject and mysqlfetcharray?   Hi friends, MySQL fetch object will collect first single matching record where mysqlfetcharray
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 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
fetch values in dropdown
fetch values in dropdown  in my application i want fetch dropdown values in jsp page through servlet. means i have to fetch the database fields values in array variable of servlet and then i have to print those values in dropdown
data insertion and fetch 1
data insertion and fetch 1  @@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ <...;Gender</b><input type="radio" name="sex" value="male">Male <input type="radio" name="sex" value="female">Female<br>
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  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
PDO Fetch Into
PDO Fetch Into: Like in the previous tutorial, we will deal with OOP concept in this tutorial. In PHP PDO::FETCH_INTO is a constant which allows us to fetch the data from an existing database into an instance or object of a class
What is the difference between mysql_fetch_object and mysql_fetch_array?
What is the difference between mysql_fetch_object and mysql_fetch_array?  What is the difference between mysqlfetchobject and mysqlfetcharray
PDO Fetch Execute
($sql); $result=$stmt->fetch(PDO::FETCH_ASSOC); echo "<table border...PDO Fetch Mode: We have studied before in the earlier tutorials that how to connect with a database and how to fetch data from the tables, in many times we
What are the differences between mysql_fetch_array(), mysql_fetch_object(), mysql_fetch_row()?
What are the differences between mysql_fetch_array(), mysql_fetch_object(), mysql_fetch_row()?  What are the differences between mysqlfetcharray(), mysqlfetchobject(), mysqlfetchrow
how to fetch data from servlet ????
how to fetch data from servlet ????  how to fetch data from servlet
fetch data from database in javascript
fetch data from database in javascript   How to fetch data from database in JavaScript when it is a leap year
SQL Out Parameter
Procedure call abc(@y); Fetch Value... SQL Out Parameter       SQL Out Parameter allows the stored procedure to the pass data
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 mysql fetch array example
php mysql fetch array example  How to fetch data from mysql and store it into an array in PHP? Please post an example. Thanks in Advance
query to fetch the highest record in a table
query to fetch the highest record in a table  Write a query to fetch the highest record in a table, based on a record, say salary field in the empsalary table
PDO Fetch Lazy
student"; $stmt=$dbh->query($sql); $obj=$stmt->fetch(PDO::FETCH_LAZY); print...PDO Fetch Lazy: PDO::FETCH_LAZY is the combination of PDO::FETCH_OBJ and PDO::FETCH_BOTH. It displays the query which has been made along with the object
how to fetch values from .properties to a html file
how to fetch values from .properties to a html file  I have a .properties file with some key value pairs in it. I need to fetch the values from this .properties file into a html file.Please let me know how to do
Hibernate Criteria Fetch Size Example
Hibernate Criteria Fetch Size Example  I want example of Hibernate Criteria Fetch Size. Share me the best example program and tutorial of Hibernate Criteria Fetch Size. Thanks   Best Example of Hibernate Criteria Fetch
PDO Fetch Num
;query($sql); $result=$stmt->fetch(PDO::FETCH_NUM); echo "<table...PDO Fetch Num: We've discussed in the previous tutorial about PDO::FETCH... index of the result unlike the PDO::FETCH_ASSOC which returns the name
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
PDO Fetch Object
to database"; $sql="select * from student"; $stmt=$dbh->query($sql); $obj=$stmt->fetch(PDO::FETCH_OBJ); echo $obj->name."...PDO Fetch Object: This is another way to access the data of a table
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
PDO Fetch Both
PDO Fetch Both: In the previous two examples we have seen the two methods... type), PDO provides the solution as PDO::FETCH_BOTH produces, with the help of this function we can achieve both type of output. PDO::FETCH_BOTH produces both
 

 

 

DMCA.com