[Veritas-bu] Parsing BPIMMEDIA
2006-11-01 18:03:55
Subject: |
[Veritas-bu] Parsing BPIMMEDIA |
From: |
RMajor at vericenter.com (Major, Rusty) |
Date: |
Wed, 1 Nov 2006 17:03:55 -0600 |
This formula will work in excel, if you'd like to use that:
=DATE(1970,1,1)+A1/86400
The formula is expecting the Unix time to be in cell A1;change it if you
need to. Paste that forumla into a cell and format the cell so that it
comes up with the date and time format you like.
-Rusty
-----Original Message-----
From: veritas-bu-bounces at mailman.eng.auburn.edu
[mailto:veritas-bu-bounces at mailman.eng.auburn.edu] On Behalf Of bob944
Sent: Wednesday, November 01, 2006 4:23 PM
To: veritas-bu at mailman.eng.auburn.edu
Cc: Humenik.Joe at bls.gov; JMARTI05 at intersil.com
Subject: Re: [Veritas-bu] Parsing BPIMMEDIA
> Exactly how am I supposed to convert "1163569541" into a time & date?
/usr/openv/netbackup/bin/bpdbm -ctime 1163569541
As Joe realized, it's normal Unix time, so gawk or any other software
with date routines will work, do it faster, not require root and give
you date-format options.
_______________________________________________
Veritas-bu maillist - Veritas-bu at mailman.eng.auburn.edu
http://mailman.eng.auburn.edu/mailman/listinfo/veritas-bu
|
|
|