time dates - Search results in mailing lists

2014-10-01 16:26:15 | libpq binary data (thilo@riessner.de)

date + time) as epoch, content FROM daten .....); In that database, the timestamp ist stored in the two fields

2013-05-22 16:52:20 | Re: - pgaql binary data date time fornats (Neeraj Rai)

date time. However, i am assuming there are functions to covert unix time to pgtimestamptz

2011-09-29 00:33:52 | Npgsql 2.0.12 beta 2 released (Francisco Figueiredo Jr.)

Date and Time Formats. Thanks Hans Peter for patch Fixes to VS.Net project properties

2009-11-21 16:49:47 | Re: ecpg & 8.3 -> 8.4 migration (Mark Richardson)

Date: Friday, November 20, 2009, 5:02 PM Bosco Rama writes: Upon poking around in the ecpg sources, I discover that it has its own list of "unreserved" keywords and pays no attention whatsoever

2008-05-19 03:17:02 | Re: pg_subtrans directory grows over 1 GB, is there a way to control it (Dennis Wang)

time.   Dennis   > To: dennis_02_2002@hotmail.com > CC: pgsql-interfaces@postgresql.org > Subject: Re: [INTERFACES] pg_subtrans directory grows over 1 GB, is there a way to control it? > Date

2007-06-04 21:57:42 | Re: Bytea network traffic: binary vs text result format (Andrew McNamara)

date, time and numeric, so what would libpq convert to? Any chosen format will only

2007-05-21 18:55:08 | Re: PQgetvalue failed to return column value for non-text data in binary format (Jeff Lynn)

time data). For clarification, we deal with various business partners that we have to import/export large amount of data between heterogeneous databases that the wonderful technology of database replication does not apply

2007-01-26 16:08:09 | Query regarding PostgreSQL date/time binary format for libpq (Shoaib Naazir)

date to PostgreSQL in binary format using the libpq interface. I have walked through the PostgreSQL code base, did find some reference to the date/time binary format but didn't get the exact format

2006-07-31 10:05:56 | Re: SPI_getvalue fails ()

time(NULL); struct tm *c_date = localtime(&t); char *t_now=strdup(asctime(c_date

2006-06-28 11:49:53 | Creating a new type (Rodrigo Sakai)

time_interval ( Tbegin date, Tend date ) And when use this new type in my tables

2006-06-20 11:44:48 | Re: help with error message from perl Pg (Tom Lane)

time on this, make sure your DBI and DBD::Pg modules are up-to-date

2005-10-14 17:00:16 | Re: [GENERAL] binary timestamp conversion (H Hale)

time. (After conversion to host byte order). -946686612744257 -946684195712577 -946684196834881 I then tried using PGTYPEStimestamp_to_asc() just to see what it does and get.... 1969-12-31 23:07:28.818367 1969

2005-09-08 15:12:41 | getting julian number from date in libpq (Norman Yamada)

date is automagically converted into whatever my DATESTYLE is at the time. How can I just

2005-06-13 11:23:07 | Re: Will libpq 8 PQ*cancel functions work with 7.4 servers? (Volkan YAZICI)

date, new code is available only in 8.0 releases. You need to patch your 7.4 libpq library for similar functionality. (I didn't try it but it should work when you try patch related source

2005-04-08 02:02:21 | Re: What is the binary format for timestamps? (ljb)

DATE. A time is returned as an 8-byte big-endian double precision number of seconds