Database independent:
1) Define a display only field of type date 2) Set value 01/01/1970 char in the newly created field 3) Define a result field of type date/time 4) (2) step + integer value = (3) step ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Veeral J Oza Sent: Friday, December 08, 2006 12:16 PM To: [email protected] Subject: Retrieving Date from SQL Hi All, Remedy data type "Date" is stored as an integer in the SQL Server database. It is stored as the number of seconds from 1st Jan 1970. Now I am using a SELECT query to read this value in a character (There is a requirement that I cannot read this into a date field on Remedy). The value returned is an integer. Is there a way through which I can convert this integer value into date? Environment: ARS 6.3 SQL Server 2000. Regards, Veeral Oza, Application Analyst, Wipro Technologies Cell: +91 9422771736 Desk: +91 20 39102370 The information contained in this electronic message and any attachments to this message are intended for the exclusive use of the addressee(s) and may contain proprietary, confidential or privileged information. If you are not the intended recipient, you should not disseminate, distribute or copy this e-mail. Please notify the sender immediately and destroy all copies of this message and any attachments. WARNING: Computer viruses can be transmitted via email. The recipient should check this email and any attachments for the presence of viruses. The company accepts no liability for any damage caused by any virus transmitted by this email. www.wipro.com __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
-- *****DISCLAIMER***** The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorized to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking action in reliance of the contents of this information is strictly prohibited and may be unlawful. Orange Romania S.A. is neither liable for the proper, complete transmission of the information contained in this communication nor any delay in its receipt. *****END OF DISCLAIMER***** _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
