By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,836 Members | 1,840 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,836 IT Pros & Developers. It's quick & easy.

beginner query help

P: n/a
Hi all, trying to run a query against a table, to pull the date out, and
order it. problem is, the date is stored in character (string) format,
not as an actual timestamp, so parsing it back into an offical 'date' is
proving tricky.
the last query that I ran, that I'm pretty sure should be working looks
like this:

(stdtime is the field with the date in numeric format, normally outpus
as: Tue Jan 6 11:36:24 2004)
select * from "table" where ticket = xxxxx order by
to_timestamp('stdtime', 'Day, Mon, DD, HH24:MI:SS, YYYY');

Something tells me this has to be wrong in some obvious way that lack of
sleep is blinding me from. :-)

thanks in advance.

-Todd Hought
to*********@echostar.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org

Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
try this

select cast('Tue Jan 6 13:36:24 2004' as timestamp)

Andrew Bartley

-----Original Message-----
From: pg*****************@postgresql.org
[mailto:pg*****************@postgresql.org]On Behalf Of Hought, Todd
Sent: Friday, 9 January 2004 7:49 AM
To: postgres
Subject: [GENERAL] beginner query help
Hi all, trying to run a query against a table, to pull the date out, and
order it. problem is, the date is stored in character (string) format,
not as an actual timestamp, so parsing it back into an offical 'date' is
proving tricky.
the last query that I ran, that I'm pretty sure should be working looks
like this:

(stdtime is the field with the date in numeric format, normally outpus
as: Tue Jan 6 11:36:24 2004)
select * from "table" where ticket = xxxxx order by
to_timestamp('stdtime', 'Day, Mon, DD, HH24:MI:SS, YYYY');

Something tells me this has to be wrong in some obvious way that lack of
sleep is blinding me from. :-)

thanks in advance.

-Todd Hought
to*********@echostar.com

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org


---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.