I'm with Grasshopper - removing ambiguity with MMM is the way to go . . although I have to confess to using <context>_YYYYMMDD_HHmmSS for time-series files where I control the...

Friends

Well, we HAVE come a long way from T-SQL and TIme Zones, eh?

I've been keeping my head down as I didn't want to step into a flame, but there are...

Um ... that's all well and good, provided the App/UI is aware...

If you think Time Zones are a bother, just think about the similar - but different - issue of Daylight Saving Time (DST). An offset from the Offset as...

Colleagues

"The one and only case I'm aware of is this one : Let's say you want to get the nth line of a big query"

The principle is:

 DECLARE @datStart datetime

 DECLARE @datEnd...