Re: Problems reformatting Unix timestamp with strftime

On Fri, 16 Feb 2001 at 02:03:42, eschmid+sic@s.netic.de writes

with the same effect - 20010213173654 becomes Monday, 18th January 2038. Is there a problem with the way I'm passing the timestamp to the date command?

Your timestamp looks bogus. On normal systems this can only be a 32 bit integer and there will be an overflow at that time.

The timestamp is created within MySQL and means 17:36:54 on 13th February 2001. I suppose I was wrong in assuming that this is Unix format? In which case, is there a way I can process such a date from MySQL directly using a command like strftime() or date()? Or is it an uncommon timestamp format to have to process? If there isn't a way of processing this with a simple command I'll admit defeat and use substrings ;-) Thanks again. -- Steven "Sponges grow in the ocean... that *kills* me. I wonder how much deeper they'd be if that didn't happen." - Steven Wright