|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
RE: [HELP
Prakash,
Try this SQL syntax for your date conversion.
,to_char(new_time((to_date('01-jan-70', 'dd-mon-rr') +
ExtData."FileDateTime"/86400),'GMT','EST'),'dd-Mon-yyyy HH24:mi:ss')
AsOfDate
Regards,
Jim
-----Original Message-----
From: Prakash G (BanW/CXR) * [mailto:
Sent: Saturday, May 10, 2003 6:06 AM
To:
Subject: [EDI-L] [HELP
Hello,
We are using Gentran 2.1.1 & DB Oracle 8.1.5.
I am trying to take a report from oracle from the "interchange_tb" wherein
the date of interchange is stored. It looks to me that it is encrypted.
Even though in Oracle table, it shows the field type as "number". The data
stored is something like this:
Oracle data Actual from Interchange
1048330894 22.02.03 16:31:55
1048330900 22.02.03 16:31:56
Can somebody help me out in decrypting this date...
With Best Regards
Prakash G
Motor Industries Co. Ltd.,
Dept. : BanW/CXR
Phone: +91 80 299 6024
Fax : +91 80 229 0917 / Extn: 6024
Email:
[Non-text portions of this message have been removed]
To unsubscribe from this group, send an email to:
Message Identifiers: <SALES>, <JOBS>, <LIST>, <TECH>, <MISC>, <EVENT>,
<OFF-TOPIC>
Access the list online at: http://groups.yahoo.com/group/EDI-L
Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
