Hi everyone,
In the following code:
sub DATEJOINED{
my %arg = @_;
if (! $arg{USER}) {return undef}
return $arg{USER}->get(field=>'RegistrationDate');
}
The field Registration date is returned from the mysql table for the user
who is currently logged in in the following format:
Thu, Mar 1st, 2001
What I would like to do is change this date to the raw format (i.e.
20010801)
Can anyone please tell me how I can do this?
I tried the following, but get a bunch of errors!
sub DATEJOINEDRAW {
my %arg = @_;
if (! $arg{USER}) {return undef}
return $arg{USER}->get(field=>'DATE_FORMAT(RegistrationDate,
'%M %e, %Y')');
Thanks so much.
---------------------------------------------------------------------
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
