date formating

I posted this in the coding forum, but never got the answer I wanted.... so I guess I will have to try here

I have got a date query that I need to select from a Microsoft SQL database.

The following query works fine on a MySql database, but get I get error on a MS 2000 db.

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

The MS Sql 2000 error reports:

Warning: MS SQL message: 'DATE_FORMAT' is not a recognized function name. (severity 15).

the error msg tells you everything, doesn't it? 😉

MSSQL doesn't have a DATE_FORMAT() function!!

so either search for an alternative or (what I'd prefer) change the
columntype to int and save the date as (PHP!)timestamp

the date formatting is much easier with PHP then and you don't
have to care about SQL functions

Originally posted by JakesSA
I posted this in the coding forum, but never got the answer I wanted.... so I guess I will have to try here

Not true. This is called crossposting, and is generally frowned upon. Not a big deal, just be aware of it...