Real Software Forums
http://forums.realsoftware.com/

Postgre SQL - best column type to use for datetime
http://forums.realsoftware.com/viewtopic.php?f=3&t=47881
Page 1 of 1

Author:  tseyfarth [ Tue May 14, 2013 6:23 pm ]
Post subject:  Postgre SQL - best column type to use for datetime

Hello all,

What is the best column type to use when creating a Postgre SQL date and time column. I prefer to use a column type that accepts SQLdatetime strings, but not sure which of the allowed types I should choose.

Advice anyone?

Thank you,
Tim

Author:  Jym [ Tue May 14, 2013 6:37 pm ]
Post subject:  Re: Postgre SQL - best column type to use for datetime

http://www.postgresql.org/docs/8.0/stat ... etime.html

Timestamp and continue using SQL date time

Author:  Thom McGrath [ Tue May 14, 2013 6:59 pm ]
Post subject:  Re: Postgre SQL - best column type to use for datetime

Be aware of TIMESTAMP columns that come in both WITH TIME ZONE and WITHOUT TIME ZONE. If you're familiar with SQL DateTime, without time zone is probably most familiar. But I'd recommend using with time zone, PG can do a lot of awesome stuff with timestamps with time zones.

Author:  tseyfarth [ Tue May 14, 2013 7:57 pm ]
Post subject:  Re: Postgre SQL - best column type to use for datetime

Thanks guys!

One more. Does the datetime stamp occur automatically, or do I provide the date/time?

Thank you again!
Tim

Page 1 of 1 All times are UTC - 5 hours
Powered by phpBB © 2000, 2002, 2005, 2007 phpBB Group
http://www.phpbb.com/