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.