Posted by schal on 01/16/07 03:50

robert
Thank you very much for clearing that
Erland
thanks for refering me to the article
the tips are very imformative and helpful
__

Erland Sommarskog wrote:
> schal (shivaramchalla@gmail.com) writes:
> > where x.event_date >= {ts '1980-01-01 00:00:00'}
> > versus like this:
> > where x.event_date >= '1980-01-01 00:00:00'
> >
> > what benifit does it add to later form of writing?
>
> In addition to Robert's post, Tibor Karaszi's article on date format gives
> some more information:
> http://www.karaszi.com/SQLServer/info_datetime.asp.
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

[Back to original message]