Different Date in Database As Compared to Application
Posted: Thu Jul 30, 2015 11:22 am
We are running into a situation where the date represented in the Select application shows one value and the database is showing another. As an example, order #270-140701008 shows an Escrow Closed Date/Time in the application as '12/31/2014 06:47 PM'. In the database, however, it shows 2015-01-01 00:47:00.000 or '01/01/2015 12:47 AM'. Is there an explanation as to why this is happening?
Code: Select all
SELECT o.Number,e.ClosedDate
FROM SelectDb.pfm.[Order] o
LEFT JOIN SelectDb.pfm.Escrow e ON e.RootId# = o.RootId#
WHERE o.Number = '270-140701008'