|
[EDI-L Mailing List Archive Home]
[Message List]
[Reply To This Message]
Re: [HELP
It's a UNIX style-date: the number of seconds elapsed from the start of
January 1, 1970. There are 86400 seconds in a day. That makes 31536000
seconds in a non-leap year. So, there are a little more than 33 years'
worth of seconds in your first example, 1048330894 - making a date
sometime in early 2003.
William J. Kammerer
Novannet, LLC.
Columbus, US-OH 43221-3859
+1 (614) 487-0320
----- Original Message -----
From: "Prakash G (BanW/CXR) *" <
To: <
Sent: Saturday, 10 May, 2003 06:05 AM
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:
|
 |
Subscribe in XML format
| RSS 2.0 |
|
| Atom 0.3 |
|
|
Cart
