Turning TSQLTimeStamp into TDateTime

Turning TSQLTimeStamp into TDateTime

Postby simasware » Wed 08 Jul 2009 17:42

Hello everybody!

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

Thanks.

:o
simasware
 
Posts: 3
Joined: Wed 08 Jul 2009 17:39
Location: Itajaí, SC, Brazil

Postby Plash » Thu 09 Jul 2009 07:11

Starting with Delphi 2007 dbExpress supports only TSQLTimeStamp fields.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby 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.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby 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 :( )
simasware
 
Posts: 3
Joined: Wed 08 Jul 2009 17:39
Location: Itajaí, SC, Brazil

Postby Plash » Fri 10 Jul 2009 09:27

Please specify your Delphi version.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09

Postby simasware » Fri 10 Jul 2009 11:04

Delphi 2009 with the latest updates.
simasware
 
Posts: 3
Joined: Wed 08 Jul 2009 17:39
Location: Itajaí, SC, Brazil

Postby Plash » Mon 13 Jul 2009 07:25

Our MySQL driver also creates TSQLTimeStampField for DATETIME columns.

You cannot create TDateTimeField under Delphi 2009.
Plash
Devart Team
 
Posts: 2844
Joined: Wed 10 May 2006 07:09


Return to dbExpress driver for Oracle