Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-19 Thread Gavin Flower
On 20/01/13 04:40, Kevin Grittner wrote: Rich Shepard wrote: On Fri, 18 Jan 2013, Adrian Klaver wrote: test=> SELECT ('2012-10-29 '||'10:19')::timestamp; timestamp - 2012-10-29 10:19:00 Thanks, Adrian. I suspected it was simple but I could not find a reference to the syn

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-19 Thread Kevin Grittner
Rich Shepard wrote: > On Fri, 18 Jan 2013, Adrian Klaver wrote: > >> test=> SELECT ('2012-10-29 '||'10:19')::timestamp; >> timestamp >> - >> 2012-10-29 10:19:00 > >  Thanks, Adrian. I suspected it was simple but I could not find a reference > to the syntax. Of course, since y

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-19 Thread Rich Shepard
On Fri, 18 Jan 2013, Adrian Klaver wrote: test=> SELECT ('2012-10-29 '||'10:19')::timestamp; timestamp - 2012-10-29 10:19:00 Thanks, Adrian. I suspected it was simple but I could not find a reference to the syntax. Much appreciated, Rich -- Sent via pgsql-genera

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-18 Thread Adrian Klaver
On 01/18/2013 04:26 PM, Rich Shepard wrote: On Fri, 18 Jan 2013, Adrian Klaver wrote: How are they stored, as date and time type, strings, other? Adrian, ISO date and time. A sample of the data would help also. Example: 2012-10-29 | 10:19 | 2012-10-30 | 09:40 Realized this

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-18 Thread Steven Schlansker
On Jan 18, 2013, at 4:26 PM, Rich Shepard wrote: > On Fri, 18 Jan 2013, Adrian Klaver wrote: > >> How are they stored, as date and time type, strings, other? > > Adrian, > > ISO date and time. > >> A sample of the data would help also. > > Example: 2012-10-29 | 10:19 | 2012-10-30 |

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-18 Thread Adrian Klaver
On 01/18/2013 04:26 PM, Rich Shepard wrote: On Fri, 18 Jan 2013, Adrian Klaver wrote: How are they stored, as date and time type, strings, other? Adrian, ISO date and time. A sample of the data would help also. Example: 2012-10-29 | 10:19 | 2012-10-30 | 09:40 test=> SELECT

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-18 Thread Rich Shepard
On Fri, 18 Jan 2013, Adrian Klaver wrote: How are they stored, as date and time type, strings, other? Adrian, ISO date and time. A sample of the data would help also. Example: 2012-10-29 | 10:19 | 2012-10-30 | 09:40 Rich -- Sent via pgsql-general mailing list (pgsql-general@

Re: [GENERAL] Combine Date and Time Columns to Timestamp

2013-01-18 Thread Adrian Klaver
On 01/18/2013 03:31 PM, Rich Shepard wrote: My Web searching foo fails me, and I don't see the answer in the postgres docs so I hope someone here can point me in the proper direction. There is a table for bacteriological data that contains two columns for the date and time the water was co