How do I convert a SQL Server Date to a Java Script Date?

Question

I am pulling back data from a SQL Server database and converting to JSON before returing to a Java Script powered Client.

They would like the String in a Java Script Format.

Answer 1

The Java Script date is based on Unix / Epoch time, which is the number of seconds that have elapsed since 12AM 1st January 1970 (UTC).

This date conversion can be realised with a single line of code:

• qie.deduceDate(<SQL Date>).getTime();

The key here is the Date.getTime() method, which will return the number of seconds between the epoch and argument date time intervals.