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
