[AccessD] SQL 2005 - disambiguous DateTime format

Stuart McLachlan stuart at lexacorp.com.pg
Sun Aug 17 19:07:23 CDT 2008


The other  big advantage is that YYYY MM DD sorts correctly even if it ends up being 
treated by some application as a simple text string.

On 16 Aug 2008 at 14:22, Arthur Fuller wrote:

> Been there, done that many times, and agree 100%. Not only that, but I deem
> this the only sensible format, first because it's unambiguous and second
> because it respects scale. Year-month-day|-hour|. Nobody can mistake a
> value. It is obvious and the particular nationality does not get in the way,
> unless perhaps you are using the Chinese calendar.
> 
> Arthur
> -- 
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com

-- 
Stuart Mclachlan





More information about the AccessD mailing list