Get date from sql server datetime

Question

I need to get a date with SQL Server datetime , and then format the date. (i.e. 01-Jan-2000 ) I am using PHP.

SQL is currently returning 2009-02-13 22:00:00.000 .

+4

Khurram Ijaz Feb 03 '11 at 5:15

2 answers

You can combine the date in any format that you want to receive directly from mySQL query,

 SELECT DATE_FORMAT(column_name, '%d-%b-%Y') FROM tablename

+1

Hydrino Feb 03 '11 at 7:29

Dan grossman · Accepted Answer · 2011-02-03T05:19:36+0000

 echo date('dM-Y', strtotime($datetime_from_db));