On Thu, May 31, 2001 at 09:27:56AM +1000, Michael Bellears wrote:
> Hi,
>
> Our Radius server reports a users usage as the following ->
>
> ACCTSTATUSTYPE TIME_STAMP
> 1 991200195
> 2 991200243
> Where ACCTSTATUSTYPE == 1 is starttime and ACCTSTATUSTYPE == 2 is the stop
> time
>
> Which with perl, I can use the localtime function to convert 991200243 to
> Wed May 30 15:24:03 2001.
>
> What I wanted to be able to do is convert to date on the fly in my mysql
> statement, so a user could go to a webpage, enter there username/password
> date (eg. 'May') and year (eg. 2001).
The MySQL manual has a section on date/time functions. You'll find the
answer you need there.
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 5 days, processed 33,484,845 queries (72/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
