Date in SQL Server different with output in .cfm

81 Views Asked by Gede Ardiasa At 17 March 2015 at 02:55

I have SQL code like this:

select Date from AAA where ID = 1

Date value for ID = 1 is '2015-03-16'

When I execute in SQL Server it shows '2015-03-16'. But why if I execute the same query in .cfm it shows '2015-03-14' ?

All of data will have different 2 days between SQL Server and .cfm ?

There are 0 best solutions below