Search Postgresql Archives

Re: Question about copy from with timestamp format

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



How do I specify that when I use copy from? this is what I am trying right now..
copy myTable (myTimeCol, col2) from myFile delimiter as '\t'

I am not sure how to specify the time format..

thanks, murali.


On Wed, Jul 29, 2015 at 3:49 PM, Adrian Klaver <adrian.klaver@xxxxxxxxxxx> wrote:
On 07/29/2015 03:42 PM, Murali M wrote:
Hi,

I wanted to copy a file from local file system to postgres. I have
timestamp value specified as:
YYYYMMDDHH24 format -- for example:
2015072913 -- is July 29, 2015 at 13:00

how do I import this data into a timestamp field?

thanks, murali.

PS: I believe if I need the hour, I need to use timestamp (I do not want
to put the hour as a separate column). I believe date datatype does not
work, if I am right??

test=# create table ts_test(ts_fld timestamp);
CREATE TABLE

test=# insert into ts_test values (to_timestamp('2015072913', 'YYYYMMDDHH24'));
INSERT 0 1

test=# select * from ts_test ;
       ts_fld
---------------------
 2015-07-29 13:00:00
(1 row)

For more information:

http://www.postgresql.org/docs/9.4/interactive/functions-formatting.html

--
Adrian Klaver
adrian.klaver@xxxxxxxxxxx


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux