The UNIX and Linux Forums  

Go Back   The UNIX and Linux Forums > Top Forums > UNIX for Dummies Questions & Answers
Google UNIX.COM


UNIX for Dummies Questions & Answers If you're not sure where to post a UNIX or Linux question, post it here. All UNIX and Linux newbies welcome !!

More UNIX and Linux Forum Topics You Might Find Helpful
Thread Thread Starter Forum Replies Last Post
changing the format of date in unix trichyselva UNIX for Dummies Questions & Answers 5 03-20-2008 09:07 AM
date issue-find prevoius date in a patricular format bsandeep_80 UNIX for Advanced & Expert Users 3 11-15-2007 04:42 PM
Alternative of format date in HP unix epall UNIX for Dummies Questions & Answers 2 09-29-2007 10:56 PM
convert mmddyy date format to ccyyddd format?? Bhups Shell Programming and Scripting 2 09-27-2006 08:30 PM
Check for the correct date format in UNIx rawatds Shell Programming and Scripting 1 07-13-2006 03:24 AM

Closed Thread
 
Submit Tools LinkBack Thread Tools Display Modes
  #1 (permalink)  
Old 01-16-2002
Registered User
 

Join Date: Jan 2002
Location: Sydney Australia
Posts: 1
Unhappy Unix Date Format

I have an Foxbase application that saves dates in a character field using a Unix date format.

Does anyone know what the formula is to convert back to a standard date, something that can be, I hesitate to say, understood in a Windows environment, such as Excel or Access.

cheers
peter
Forum Sponsor
  #2 (permalink)  
Old 01-17-2002
LivinFree's Avatar
Goober Extraordinaire
 

Join Date: Jul 2001
Location: Portland, OR, USA
Posts: 1,584
The only thing I can think that could be would be the Unix Epoch... If it's just a really big number, it's possible that it's (I think) the number of seconds since January 1, 1970. I'ts well over a billion now...

I don't know of any way to convert it easily, short of writing a program or perl script... maybe someone else does?
  #3 (permalink)  
Old 01-17-2002
Registered User
 

Join Date: Nov 2001
Location: Reading, UK
Posts: 42
Surely if you ae importing in to Access or Excel then you can write a formula/ macro in either one of these to correctly interprete / manipulate the data.
Google The UNIX and Linux Forums
Closed Thread

Thread Tools
Display Modes




All times are GMT -7. The time now is 09:02 PM.


Powered by: vBulletin, Copyright ©2000 - 2006, Jelsoft Enterprises Limited.
The UNIX and Linux Forums Content Copyright ©1993-2008. All Rights Reserved.Ad Management by RedTyger Visit The Global Fact Book

Content Relevant URLs by vBSEO 3.2.0