Have you tried doing it at application level? You could have a temporary character field to set the Date from the Date type field and then append the time part as 12:00:00 AM to the value in the character field separated by a space, and set it to the Date/Time field.
Joe D'Souza -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] Behalf Of Atul Vohra Sent: Monday, October 01, 2007 11:28 PM To: arslist@ARSLIST.ORG 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 No virus found in this outgoing message. Checked by AVG Free Edition. Version: 7.5.488 / Virus Database: 269.13.37/1042 - Release Date: 10/1/2007 6:59 PM _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
