Re: [SQL] dates and selection

2005-08-18 Thread Josh Berkus
Joel, > 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) Um, what's wrong with: to_char(some_timestamp, 'Mon DD HH:MI:SS') ? -- Josh Berkus Aglio Database Soluti

[SQL] dates and selection

2005-08-18 Thread Joel Fradkin
After my conversion to Unicode and implementing new drivers (Thank god still up no down time J) 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 D