-
Hi cash/rawhide,
set dateformat 'dmy'
Is used tell SQL server that the input date is in certain format where it is referred to in the "SQL Query".
Example Query:
set dateformat 'dmy'
select *
from table_abc
where column_date = '11/12/2004'
-- The above query will interpret it as
Day = 11
Month = 12
Year = 2004
-- if dateformat is not set the query could have interpret it as
Day = 12
Month = 11
Year = 2004
Hope this make sense.
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
|