On Fri, Mar 13, 2009 at 10:55:18AM -0400, Justin Sherrill wrote:
> jmrodri wrote:
> > why is this a BAD query? I think this was done on purpose to return the
> > issue_date as date.
>
> The query was 'bad' because evidently date is a reserved word. Try to
> do anything as 'select id as date from rhnServer'. Wont' work. Feel
> free to look at the referenced bug for the sql error.
You are looking for
select id as "DATE" from rhnServer
here, probably.
--
Jan Pazdziora
Senior Software Engineer, Satellite Engineering, Red Hat
_______________________________________________
Spacewalk-devel mailing list
[email protected]
https://www.redhat.com/mailman/listinfo/spacewalk-devel