New topic: Postgre SQL - best column type to use for datetime
<http://forums.realsoftware.com/viewtopic.php?t=47881> Page 1 of 1 [ 4 posts ] Previous topic | Next topic Author Message tseyfarth Post subject: Postgre SQL - best column type to use for datetimePosted: Tue May 14, 2013 6:23 pm Joined: Sat Dec 04, 2010 9:14 pm Posts: 905 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 Top Jym Post subject: Re: Postgre SQL - best column type to use for datetimePosted: Tue May 14, 2013 6:37 pm Joined: Sat Oct 01, 2005 5:19 pm Posts: 3200 http://www.postgresql.org/docs/8.0/stat ... etime.html Timestamp and continue using SQL date time Top Thom McGrath Post subject: Re: Postgre SQL - best column type to use for datetimePosted: Tue May 14, 2013 6:59 pm Site Admin Joined: Tue May 06, 2008 1:07 pm Posts: 1458 Location: NotEvenOnTheMap, CT 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. _________________ Thom McGrath - @tekcor Web Framework Architect, Real Software, Inc. Top tseyfarth Post subject: Re: Postgre SQL - best column type to use for datetimePosted: Tue May 14, 2013 7:57 pm Joined: Sat Dec 04, 2010 9:14 pm Posts: 905 Thanks guys! One more. Does the datetime stamp occur automatically, or do I provide the date/time? Thank you again! Tim Top Display posts from previous: All posts1 day7 days2 weeks1 month3 months6 months1 year Sort by AuthorPost timeSubject AscendingDescending Page 1 of 1 [ 4 posts ] -- Over 1500 classes with 29000 functions in one REALbasic plug-in collection. The Monkeybread Software Realbasic Plugin v9.3. http://www.monkeybreadsoftware.de/realbasic/plugins.shtml [email protected]
