There are some Kbs on this .. following should help you.
Oracle
----------
SELECT TO_CHAR(TO_DATE('01/01/1970 00:00:00', 'MM/DD/YYYY HH24:MI:SS') +
(C3 / ( 60 * 60 * 24 )), 'MM/DD/YY HH24:MI:SS') FROM T40;
SQL
-----------
select dateadd(second, c3, "Jan 1, 1970") from T7
On 12/8/06, Veeral J Oza <[EMAIL PROTECTED]> wrote:
** Hi All,
Remedy datatype *"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"
