Date

[JakesSA]

Hi guys

The following query prints a pefect user friendly date on a MySql DB
from a timestamp:

//prints the desired date eg........................ 28 January 2003

$query = "SELECT DATE_FORMAT(timestamp, '%D %M %Y') 
                 AS  date FROM table WHERE id = 1";

What would be the Microsoft SQL 2000 version on this type of query to get the date?

any ideas?

Thanks

[mcgruff]

Genesis chapter III.2:

"And it came to pass that the Israelites spurned the open source bounty of the Lord their God, succumbing to the temptations of the horned one, Gates. Never was there such a wailing and a gnashing of teeth."

[JakesSA]

"And it came to pass that the Israelites spurned the open source bounty of the Lord their God, succumbing to the temptations of the horned one, Gates. Never was there such a wailing and a gnashing of teeth."

LOL

"And it came to pass that JakesSA spurned the man they called mcgruff their phesant, succubling to temptations of a leppers power. Never was there such a idiot on this earth, as mcgruff."

Next time, when you post something on the forum....let it be useful and not some crap you quoted out a book.