Unix_TimeStamp

[Pius, Edward]

Hello,
 
        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.
 
        Any help would be deeply appreciated,
 
Edward Pius