Skip site navigation (1) Skip section navigation (2)

Re: cross-database time extract?

From: Greenhorn <user(dot)postgresql(at)gmail(dot)com>
To: Israel Brewster <israel(at)frontierflying(dot)com>
Cc: Adrian Klaver <aklaver(at)comcast(dot)net>, pgsql-general(at)postgresql(dot)org
Subject: Re: cross-database time extract?
Date: 2009-12-28 20:13:46
Message-ID: ddcb1c340912281213t47764e4fk7be7a544fa5c2076@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
2009/12/29 Israel Brewster <israel(at)frontierflying(dot)com>:
>
> On Dec 24, 2009, at 12:53 PM, Adrian Klaver wrote:
>
>> On Thursday 24 December 2009 1:44:58 pm Israel Brewster wrote:
>>>
>>> This is sort of a PostgreSQL question/sort of a general SQL question,
>>> so I apologize if this isn't the best place to ask. At any rate, I
>>> know in PostgreSQL you can issue a command like 'SELECT
>>> "time"(timestamp_column) from table_name' to get the time part of a
>>> timestamp. The problem is that this command for some reason requires
>>> quotes around the "time" function name, which breaks the command when
>>> used in SQLite (I don't know about MySQL yet, but I suspect the same
>>> would be true there). The program I am working on is designed to work
>>> with all three types of databases (SQLite, PostgreSQL, and MySQL) so
>>> it would be nice (save me some programing) if there was a single SQL
>>> statement to get the time portion of a timestamp that would work with
>>> all three. Is there such a beast? On a related note, why do we need
>>> the quotes around "time" for the function to work in PostgreSQL? the
>>> date function doesn't need them, so I know it's not just a general
>>> PostgreSQL formating difference. Thanks :)
>>> -----------------------------------------------
>>> Israel Brewster
>>> Computer Support Technician II
>>> Frontier Flying Service Inc.
>>> 5245 Airport Industrial Rd
>>> Fairbanks, AK 99709
>>> (907) 450-7250 x293
>>> -----------------------------------------------
>>
>> select cast(timestamp_column as time) from table_name
>

you could try select timestamp_column::time from table_name

In response to

Responses

pgsql-general by date

Next:From: Ivan Sergio BorgonovoDate: 2009-12-28 20:20:17
Subject: Re: pg_dump excluding tables content but not table schema
Previous:From: Raymond O'DonnellDate: 2009-12-28 19:39:36
Subject: Re: pg_dump excluding tables content but not table schema

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group