Обсуждение: Datetime as a time_t?
Hello, Does anyone know how to extract a datetime field as a time_t? My understanding is that PostgreSQL stores dates internally as a time_t, but I have not figured out how to extract them in that format. I have looked at the casting, and the set datestyles so far. Any ideas? Thanks, -Ryan P.S. I am using PostgreSQL 6.5.3
I have done the following to return a datetime field in unix form: select datepart('epoch', datetime) from table; Michael Fork - CCNA - MCP - A+ Network Support - Toledo Internet Access - Toledo Ohio On Thu, 6 Apr 2000, Ryan Bradetich wrote: > Hello, > > Does anyone know how to extract a datetime field as a time_t? > My understanding is that PostgreSQL stores dates internally > as a time_t, but I have not figured out how to extract them in > that format. > > I have looked at the casting, and the set datestyles so far. > Any ideas? > > Thanks, > > -Ryan > > P.S. I am using PostgreSQL 6.5.3 > >
Ryan Bradetich <ryan_bradetich@hp.com> writes: > Does anyone know how to extract a datetime field as a time_t? date_part('epoch', ...); Not exactly the first thing you'd think to try, but it works. regards, tom lane
At 10:27 AM 4/06/00 -0600, Ryan Bradetich wrote: >Does anyone know how to extract a datetime field as a time_t? >My understanding is that PostgreSQL stores dates internally >as a time_t, but I have not figured out how to extract them in >that format. abstime(datetime_field)::int8 works for both datetime and timestamp fields. Frank