What should the statement "Select Unix_timestamp()" return? When I do this in SQL Studio, it errors out. But when I do "Select Unix_timestamp(now())" it returns the current timestamp. I was expecting the second statement to return the number of seconds elapsed from 1970-01-01 00:00:00.
You've fallen for the Gotcha named_query_spec: http://dev.mysql.com/doc/maxdb/en/0f/486fab2f9611d3a98100a0c9449261/frameset.htm
SELECT <identifier> (expr, ...)
creates a result set named <identifier>. It does not call the function <identifier>, at least not when a function of that name is not known.
There is no function Unix_timestamp in MaxDB.
Daniel Dittmar
-- Daniel Dittmar SAP Labs Berlin [EMAIL PROTECTED]
-- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
