date comparison

[SirOliver]

Hi,

i am trying to compare date() function with date stored in my MS SQL (NOT MySQL) db, datetime type, but i can't find out how...

any ideas?

[khaldryck]

i don't know how is the date format in MS SQL

could you give me an output of it.

i'll still give you some exemple :

if your output is like this : 2003-03-20 10:47:32
you can have the same with date("Y-m-d H:i:s")

read more about date() in the php manual to format your output like the one of your database
also date() is only for the current date,
if you want to use another date you need to use mktime too.
like this
date("Y-m-d H:i:s", mktime($hour,$minute,$second,$month,$day,$year))

sorry i can't help more

[SirOliver]

in a bd it looks like this:

2001-03-31 00:00:00.000

when i print it on the screen it looks like this:

Mar 31 2001 12:00AM

I know that i can format date() almost any way i want, and i did format output the same way as above, but how can i compare them?
i want something like this:

$result = mssql_query("SELECT date FROM table where id=1");
$myrow = mssql_fetch_array($result);
$date = $myrow["date"];

if ($date> date(F j Y g:i A) )

{ echo "date in DB is bigger \n"; }

else
{ echo "date in DB is smaller\n"; }

[khaldryck]

that won't work because your date are not numeric.
and jan > feb in string compare.

maybe you'll have to translate your DB date into numerics
read more about MS SQL date format.
maybe there is some timestamp output (better to compare date ).

the key to success is to convert your DB date to such a format :
date("YmdHis")

that way you can then compare both date the way you want.

if MS SQL doesn't do it, you can create a function for it.
using substr() to get your date in the right order.