From: Joel Fradkin <jfradkin@wazagua.com>
To: pgsql-odbc@postgresql.org
To: pgsql-sql@postgresql.org
Subject: dates and selection
Date: Thu, 18 Aug 2005 16:36:28 -0400
Message-ID: <004c01c5a434$82d6ff70$797ba8c0@jfradkin> (raw)
After my conversion to Unicode and implementing new drivers (Thank god still
up no down time :-)) I do have an issue with some of my sql selects
concerning dates.
I know the long answer, but am asking if there is a short one.
I have in some of my slq :
(to_char(e.incidentdate, 'Mon DD YYYY'::text) || ' '::text) ||
e.incidenttime::text as incidentdate
I used to be able to sort and select by incident date and it was working ok
(I think).
Now I found I had to do something like this just to have a timestamp
(problem is I do not want the format of the time stamp, my clients want to
see the month as a string)
((to_char(e.incidentdate, 'Mon DD YYYY'::text) || ' '::text) ||
e.incidenttime::text)::timestamp as datetoselectby
Is there any way to reference the text type variable as a date selection?
(was this ever working or was I hallucinating).
Many thanks for all the help.
Joel Fradkin
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: jfradkin@wazagua.com, pgsql-odbc@postgresql.org
Subject: Re: dates and selection
In-Reply-To: <004c01c5a434$82d6ff70$797ba8c0@jfradkin>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox