Posted by Hugo Kornelis on 11/28/43 11:58

On 16 Sep 2006 06:12:07 -0700, tlyczko wrote:

>Hello, I'm new to SQL Server, working for a non-profit computerizing a
>lot of its data.
(snip)
>Where and how do I learn to specify that all fields like this should be
>in ISO format of yyyy-mm-dd??
(snip)
>The end users will likely enter mm/dd/yy or mm/dd/yyyy and it will have
>to be stored properly in the database table as column/field
>birth_date...

Hi Tom,

Read Tibor Karaszi's article "The ultimate guide to the datetime
datatypes", and you'll know everything you need to know for safely using
datetimes in SQL Server databases:

http://www.karaszi.com/SQLServer/info_datetime.asp

--
Hugo Kornelis, SQL Server MVP

• Next in forum: Re: Indexes vs Clustered Indexes
• Prev in forum: Re: Line Break in T-SQL
• Thread view: Re: formatting for a birth date field??

[Reply to this message]