Turning TSQLTimeStamp into TDateTime

simasware · Post by **simasware** » Wed 08 Jul 2009 17:42

Hello everybody!

I wanna know how can I turn TSQLTimeStamp fields into TDateTime fields.

Thanks.

Plash · Post by **Plash** » Thu 09 Jul 2009 07:11

Starting with Delphi 2007 dbExpress supports only TSQLTimeStamp fields.

Plash · Post by **Plash** » Thu 09 Jul 2009 07:59

For older dbExpess versions:
You should use Oracle DATE data type to store date-time values. In this case TDateTime fields will be created.

simasware · Post by **simasware** » Thu 09 Jul 2009 18:02

Well, if I can't use TDateTime fields, how can i turn Oracle's Date type into TDateField (I've got it using your MySQL DBX driver, but didn't with Oracle

)

Plash · Post by **Plash** » Fri 10 Jul 2009 09:27

Please specify your Delphi version.

simasware · Post by **simasware** » Fri 10 Jul 2009 11:04

Delphi 2009 with the latest updates.

Plash · Post by **Plash** » Mon 13 Jul 2009 07:25

Our MySQL driver also creates TSQLTimeStampField for DATETIME columns.

You cannot create TDateTimeField under Delphi 2009.