Costin, You could probably use one of the functions listed here: file:///usr/share/doc/postgresql-7.4.2/html/functions-formatting.html If you want the varchar -> date conversion to happen automatically, you should study this chapter: file:///usr/share/doc/postgresql-7.4.2/html/typeconv.html HTH, Csaba. On Mon, 2005-04-11 at 11:40, Costin Manda wrote: > Hello, > > I have a table with columns defines as varchar that have values in format > 'YYYY-MM-DD HH:MM:SS'. > > Now, if I do a > select timestamp '2005-10-10 10:10:10'; > I get the value just fine. I can use abstime()::integer on the result to > find the unix timestamp. (This is the simplest way I could find, are there > any others?) > > However, when I try doing the same with the values in the table I can't > get it to work. > > select timestamp setuptime from billing; - error > select timestamp(setuptime) from billing; - error > select setuptime::timestamp from billing; - error (cannot cast type > character varying to timestamp without timezone!?) > > So, how can I convert this string into a timestamp, pleeease! :( > > > > > ------------------------- > E-Mail powered by MadNet. > http://www.madnet.ro/ > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings ---------------------------(end of broadcast)--------------------------- TIP 2: you can get off all lists at once with the unregister command (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)
