MySQL and MSSQL dates

[adrian_quah]

hello guys,

I noticed that the datetime formats for MySQL and MSSQL are similar. correct me if i'm wrong.

for MySQL:
2001-01-07 00:00:00

for MSSQL:
2001-01-07 00:00:00.000

I'd like my scripts to function correctly for both of these date formats. Think it'll be okay? the functions are mostly like sort by date and search for entries from a certain dates..and normal operations like finding the number of days left..etc..

I dont have the privelege of using MSSQL yet, but will be porting my app to it later on in development. thanks for sharing!

Adrian🙂

[barand]

I've just ported an app from mySql to Access then to mssql and routines like the one below for calculating how many days before a contract expires have remained unaltered.

function daysLeft($d) {
	$res = (strtotime($d) - time()) / (24*60*60);
	return (int)$res;
}

where $d is the contract date from the database

[adrian_quah]

Thanks Barand, that's reassuring, really 😃