Dates and Times
Previous Topic  Next Topic 

Why are dates displayed Backwards

MS Sql Server is internationalised to a point, however SQL as a language is less so. A date formatted thus 1999-12-31 14:29.59 is unambiguous as is 1999-07-01 23:59:59. We can never be sure about 07/01/2001 - is it July, or Jan.

The most unambiguous is of course 01 jul 2001 - generally in MS software this will be

dd MMM yyyy HH:mm:ss

Why are some dates on Talons SQL displayed in such verbose detail


Tuesday, 20 December 2005 18:51:33 [+10:00] Loading  finished

2005-12-20 18:51:33 Creating Bed day Products

Well I am in Melbourne and I am +11:00  in summer and so this reminds me that you are not and  that you are UTC +10:00 !

Talons Locks, why are the times funny

In this case, Lock times are defined in UTC as if, for example, TALONS was to work in two timezones (watch them chaps on the goldcoast, it may happen) the system needs to normalise any effect this may have. Truth is ALL times for ALL things should be normalised to UTC, as the question of Daylight saving effect on Admissions Dates and times can be great especially when it comes to episode matching, however you do not have it yet, and date/times are NOT stored as UTC.