Re: [GENERAL] Problem using CASTed timestamp column

2010-11-11 Thread Richard Broersma
On Thu, Nov 11, 2010 at 2:26 PM, Digimer wrote: > http://pastebin.com/sExiBynp >  Any hints on what I am doing wrong? You can't refer to a column alias name in the order by clause unfortunately. You'll need to either nest this query in another query to use the alias name, or you have to use a p

[GENERAL] Problem using CASTed timestamp column

2010-11-11 Thread Digimer
Hi all, I've got an odd problem. I've got a column with a non-standard date/time in it that I carve up and re-cast as a timestamp. This works fine. Now though, I am trying to check/restrict my results to dates before now() and it's telling me that the columns doesn't exist. http://pastebin.com/