date internal format

satya99 · Post by **satya99** » Thu Mar 06, 2008 1:39 pm

How to convert timestamp to internal format?

ex: 1999-12-28 00:00:27

Thanks

chulett · Post by **chulett** » Thu Mar 06, 2008 1:52 pm

You would use IConv and do the date and time portions separately - 'D' for data and 'MT' for time.

satya99 · Post by **satya99** » Thu Mar 06, 2008 2:00 pm

chulett wrote:You would use IConv and do the date and time portions separately - 'D' for data and 'MT' for time. ...

I need to compare timestamp, Do i need to convert into internal format then compare or can i compare the timestamp?

chulett · Post by **chulett** » Thu Mar 06, 2008 2:07 pm

Depends on the external format your timestamp is in. If it is ISO like - "YYYY-MM-DD HH24:MI:SS" - then you can compare those strings directly.