date / time with Unidac in Postgres

markdueck · Post by **markdueck** » Wed 23 Dec 2009 06:03

Hi,

I just read a post that Unidac does not support special fields -

http://www.devart.com/forums/viewtopic. ... light=date

- does this mean that UniDAC does not do any type of date / time? I'm working on a project, and I cannot find a way to get the time saved into a time field.

Mark

Plash · Post by **Plash** » Thu 24 Dec 2009 09:33

UniDAC supports date/time fields. What problem do you have with saving time values?

markdueck · Post by **markdueck** » Thu 24 Dec 2009 23:38

It tells me every time, no matter what format I save to the dataset, that the time is out of range.

The Time field is a field with no time zone. The front end/program works fine, but when applying updates to the database, Pg complains that: 'time out of range'

Postgres column is declared as a time field, IDE recognizes it as that and makes the TTimeField variable for it. It receives the time without a problem.

e.g. qryMainpost_time->Value = FormatDateTime("h:nn:ss am/pm",Now())

Regards