Formatting a date from SQL

[Anon]

I think I haven't had enough coffee today...

I went through the manual and couldn't get my tired brain around finding a way to convert SQL's 2000-08-09 00:00:00
to Aug 9 2000.

I don't need the time part. Thanks in advance for the pointers.

[Anon]

You can format it right in your SQL query e.g.

select date_format(your_date_column,'%b %e %Y') from your_table

works in mySQL...

Boris Belobrad
Belcom Bailey LLC
www.belcombailey.com

[Anon]

I'll give it a try, but I didn't see that in the MS SQL Server 7 docs.

[Anon]

Alas, doesn't work in SQL Server 7.

[Anon]

I don't know MS-SQL that well, but I think you can use something like this:

SELECT datepart(year,your_date_column) AS year, datepart(month,your_date_column) AS month, datepart(day,your_date_column) AS day FROM your_date_table

which will return integers representing date stored in your database. Then you can use PHP functions to format the look as you wish...

Boris Belobrad
Belcom Bailey LLC
www.belcombailey.com

[Anon]

just format it using th php3 command !

string date(string format, int [timestamp] );

Pasterd from the manual
Example 1. date example
print (date("l dS of F Y h:i:s A"));
print ("July 1, 2000 is on a " . date("l", mktime(0,0,0,7,1,2000)));

bye

[Anon]

I'll try that out.