On Mon, Apr 30, 2001 at 12:24:26PM +0100, Basil Hussain wrote:
> Hi,
>
> >> Does the function Unix_TimeStamp() work in MySQL under Windows NT?
> >> It doesn't seem to work here in simple queries, such as this query:
> >> Select Unix_TimeStamp();
> >
> > What about
> >
> > SELECT UNIX_TIMESTAMP(NOW())
>
> The above shouldn't be necessary - it is actually supposed to give you the
> current timestamp if called without arguments. According to the manual,
> anyway:
>
> "If called with no argument, returns a Unix timestamp..."
>
> So, if it's not working as documented under Windows, then I think
> this counts as a bug, yes?
Indeed. I hadn't used it without arguments before, and forgot about
that behavior.
Jeremy
--
Jeremy D. Zawodny, <[EMAIL PROTECTED]>
Technical Yahoo - Yahoo Finance
Desk: (408) 349-7878 Fax: (408) 349-5454 Cell: (408) 439-9951
MySQL 3.23.29: up 117 days, processed 723,589,119 queries (71/sec. avg)
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php