re: Is Datetime2 compliant with Daylight Savings Time?

QingsongYao — Sat, 06 Feb 2010 07:33:38 GMT

Hello,UndiFineD

I am not very familar with PHP, If you can use SQL Serve Profiler to trace the query sent to the SQ SQL SQ

SQL Server, I may help with it. I beleive the issue is not related to collation, but the datetime string format

since SQL Server only support certian format of the string.

UndiFineD — Fri, 05 Feb 2010 09:46:36 GMT

I am having difficulty inserting proper datetime data into my database via PHP

language is set to english (US)

collation is set to SQL_Latin1_General_CP1_CI_AS

mind the double and single quotes used here.

<?PHP

$datetime = 'convert(datetime'.date("m/d/Y H:i:s").'121)';

$query = "INSERT INTO Table (datetime) VALUES ('".."')";

$result = mssql_query($query);