Postgres Pro
Downloads
Home   >   mailing lists

Time Conversion - Mailing list pgsql-novice

From Ryan Sommers
Subject Time Conversion
Date
Msg-id 1253.66.166.104.222.1111612049.squirrel@66.166.104.222
Whole thread Raw
Responses Re: Time Conversion
List pgsql-novice
Tree view 
How can I convert a VARCHAR(25) to a timestamp? Including a fraction of a
second.

The VARCHAR(25) column is in the form: YYYY-MM-DD HH:MI:SS.fffff
where fffff is the fraction of a second.

I could use to_timestamp but I can't find a conversion specifier for the
fractional part.


--
Ryan Sommers
ryans@gamersimpact.com

pgsql-novice by date:

Previous
From: "Marubayashi, Roy (Mission Systems)"
Date:
Subject: I'd Like To See Permissions Granted
Next
From: Christopher Kings-Lynne
Date:
Subject: Re: [pgsql-advocacy] Function which gives back the nearest neighbours