Posted by schal on 01/15/07 15:34

hi Experts,
what is the purpose writing a date in the following format:

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?
Thanks in advance.
schal.

• Next in forum: Re: Auditing:Extracting changed fields from Inserted table
• Prev in forum: Re: Go and goto in one sql script gives error label not declared
• Thread view: purpose of writing dates in this format

[Reply to this message]