Re: timestamp problem !!

Nabil <nabil.attar@aws-syria.com> wrote: > thanks Jason, you've been always helping me ... > > Please i still have some fog regading this.. can u expaling me more about > the timestamp and unix timestamp... mysql's timstamp in this case is in the format: YYYYMMDDHHMMSS Unix timstamp number of seconds since 1970-01-01 > and regaring me issue i have a string with '20030714012548' what ever i got > it from (because i m getting this from MSSQL some time and then read it from > MySQL, and i need to desplay it in as 2003-07-14 only .. > > What' shall i do ? Read: http://www.mysql.com/doc/en/Date_and_time_functions.html http://www.mysql.com/doc/en/DATETIME.html > Nabil > Curt --