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