[Oledb-dev] timestamps

[Shachar Shemesh]

VANDROMME Bart wrote:
>
> Hello,
>
Hi Bart, sorry for taking so long to get back to you.
>
> I use ADO to get access to a PostGreSQL database.
>
> I'm having trouble writing a timestamp into the database.
>
Can you elaborate? What's the problem?
>
> As I saw already on you ?tracker?, the problem is still there, but is
> there going to be a solution quickly ?
>
Due to time constraints on my part (I put in volunteer work only when
paying work allows, and lately it has not), I will not have a lot of
time in the foreseeable future. Can you give the precise tracker number
you are referring to? Maybe it's an easy fix and I'll squeeze a new
version out.
>
> Does somebody have an example on how to put the timestamp into the
> database ?
>
Which would you want? A "timestamp" or a "timestamptz"? There is a
problem of extremely inconsistent time handling in Windows. So long as
you work only GMT, you should be ok. If you need local time zone, then
Windows itself is inconsistent. I have only recently realized this,
which leads to the fact that you shrug and lose precision, but go ahead
anyways, which is what I'll probably end up doing.

For the time being, there is no good translation from OLE DB time stamps
to PG.
>
> Regards,
>
> Bart
>
Shachar