Page 1 of 1

Turning TSQLTimeStamp into TDateTime

Posted: Wed 08 Jul 2009 17:42
by simasware
Hello everybody!

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

Thanks.

:o

Posted: Thu 09 Jul 2009 07:11
by Plash
Starting with Delphi 2007 dbExpress supports only TSQLTimeStamp fields.

Posted: Thu 09 Jul 2009 07:59
by Plash
For older dbExpess versions:
You should use Oracle DATE data type to store date-time values. In this case TDateTime fields will be created.

Posted: Thu 09 Jul 2009 18:02
by simasware
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 :( )

Posted: Fri 10 Jul 2009 09:27
by Plash
Please specify your Delphi version.

Posted: Fri 10 Jul 2009 11:04
by simasware
Delphi 2009 with the latest updates.

Posted: Mon 13 Jul 2009 07:25
by Plash
Our MySQL driver also creates TSQLTimeStampField for DATETIME columns.

You cannot create TDateTimeField under Delphi 2009.