December 13, 2006 at 7:37 am
Hi,
in tsql there is a common format for datetime (regardless regional settings)?
I use : 'mm/dd/yyyy' to access cols in database,
but someone says that the right one is: yyyy-dd-mm.
Any suggestion about that?
Thank a lot
December 13, 2006 at 7:43 am
sorry:
when is written:
but someone says that the right one is: yyyy-dd-mm.
the right one is: yyyy-mm-dd
Thank
December 13, 2006 at 8:36 am
Almost, but not quite.
There's only one format that is unaware of language or datesettings - yyyymmdd
(in T-SQL it's convert style 112)
See also these articles:
How do I delimit/format dates for database entry?
The ultimate guide to the datetime datatypes
http://www.karaszi.com/SQLServer/info_datetime.asp
/Kenneth
December 13, 2006 at 10:30 am
Thank,
useful suggestions
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply