You need to take care of Time Zone, by default it is GMT, you need to add / subtract time in sql query according to your local time zone.
Warm Regards, Jignesh Shah ------------------------------------------ ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Benjamin Trimmer Sent: Tuesday, October 02, 2007 6:29 PM To: [email protected] Subject: Re: Convert Date in to timestamp in remedy ** UPDATE [table2] SET [field_to_modify] = DATEADD(s, [Remedy_DT_Field] + [additional time in seconds if necessary], '01-01-1970 00:00:00') WHERE [criteria] Regards, Ben Trimmer Atul Vohra <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/02/2007 07:49 AM Please respond to [email protected] To [email protected] cc Subject Re: Convert Date in to timestamp in remedy ** Hi Benjamin, Appreciate your response but what I am looking for is an update statement that sets the date field using a Remedy date field. Atul ----- Original Message ----- From: "Benjamin Trimmer" To: [email protected] Subject: Re: Convert Date in to timestamp in remedy Date: Tue, 2 Oct 2007 07:12:14 -0500 ** Atul. This query will return you a Remedy date/time field as a SQL date: SELECT DATEADD(s, [Remedy_DT_Field], '01-01-1970 00:00:00' FROM [tablename] Regards, Ben Trimmer Atul Vohra <[EMAIL PROTECTED]> Sent by: "Action Request System discussion list(ARSList)" <[email protected]> 10/01/2007 10:27 PM Please respond to [email protected] To [email protected] cc Subject Convert Date in to timestamp in remedy Hi, We are using ARS 6.3, MS SQL. I want to update a date field using direct sql - can some one help me with this. Is there a function to convert the date field in to timestamp or can I use the sql to update the date field directly. Thanks Atul ________________________________________________________________________ _______ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are" * * * * * * * * * * * * * * * * * * * * * * * * * IMPORTANT NOTICE* * * * * * * * * * * * * * * * * * * * * * * * * Unless otherwise indicated or obvious from the nature of the transmittal, the information contained in this email message is CONFIDENTIAL information intended for the use of the individual or entity named herein. If the reader of this message is not the intended recipient, or the employee or agent responsible to deliver it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify the sender using the above contact information or by return email and delete this message and any copies from your computer system. Thank you. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
