See attached for the MS-SQL date and date/time conversion functions I posted to the list last year. The two functions for date/time conversion take into account daylight saving time (both pre and post 2007 US DST rules). The functions simply need to be adjusted to match the correct offsets from GMT in your time zone during standard and daylight saving time.
The other two functions are for converting date-only values.
HTH,
--Thomas
Thomas Bean
Remedy System Administrator
ITS Products Group
Ph: 314-977-3740
[EMAIL PROTECTED]
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org
Platinum Sponsor: www.rmsportal.com ARSlist: "Where the Answers Are"
<<slu_2c.gif>>
datetime_to_DateOnlyInt.sql
Description: Binary data
convert_date_to_epoch.sql
Description: Binary data
convert_epoch_to_date.sql
Description: Binary data
DateOnlyInt_to_datetime.sql
Description: Binary data
