We use this a lot--SQL Server specific
SELECT dateadd (ss, YOUR_INTEGER_FIELD, '1970-01-01') from ....
This returns a date/time value with your default format: You can further add
date formatting commands to this statement to get it into "prettier" formats if
your default format needs to be changed.
Tim
"CONDREA, Daniel" <[EMAIL PROTECTED]> wrote:
** v\:* {behavior:url(#default#VML);} o\:*
{behavior:url(#default#VML);} w\:* {behavior:url(#default#VML);} .shape
{behavior:url(#default#VML);} st1\:*{behavior:url(#default#ieooui) }
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___
__20060125_______________________This posting was submitted with HTML in it___
--
*****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"
_______________________________________________________________________________
UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the
Answers Are"
