http://www.sqlservercentral.com/Content tagged User-Defined functions, Advanced Querying posted on SQLServerCentral.comen-us360sjones@sqlservercentral.com (Steve Jones)Dinesh looks at the date functions, how to work with time zones (or not), and does a brief comparison to see how you do similar tasks in Oracle. http://www.sqlservercentral.com/articles/Advanced+Querying/datetimevaluesandtimezones/1234/2003/12/22http://www.sqlservercentral.com/articles/Advanced+Querying/datetimevaluesandtimezones/1234/