how to convert '2005-9-22 3:9:00' to 200509220309

[andrewxie]

i use
SELECT concat(YEAR(now(), MONTH(now()), DAY(now()), HOUR(now()), MINUTE(now()));

return 200592239. but i want double digit hour and minute

anybody knows.

 

[sleipnir214]

I wouldn't use concat() for this. I'd use date_format():

select date_format(now(), '%Y%m%d%H%i')

Want the best answers? Ask the best questions!

TANSTAAFL!!

 

[r937]

i wouldn't use date_format() for this, i'd use date arithmetic:

[tt]select floor(now()/100) as date_number[/tt]



r937.com | rudy.ca

 

[KarveR]

just to be more diverse.

select substring(NOW() + 0,1,12);


______________________________________________________________________
There's no present like the time, they say. - Henry's Cat.

 

[andrewxie]

thanks both of you. they all works. have a nice day!

 

[andrewxie]

by the way, anybody know built-in function in perl to convert localtime() to '200509230809' except the following function.

sub convertDate
{
my ($varDate) = @_;
if (day$(varDate) < 10)
{
dd = "0"day($varDate);
}
else
{
dd = day($varDate);
}
if (month($varDate) < 10))
{
$mm = "0".month($varDate);
}
else
{
$mm = month($varDate);
}
$convertDate = year(varDate)$mm$dd;
}

 

[TonyGroves]

How about:
[tt]
@lt=localtime(time);
sprintf
(
$datestring,"%d%02d%02d%02d%02d",
$lt[5]+1900,$lt[4]+1,$lt[3],$lt[2],$lt[1]
);
[/tt]

 

[TonyGroves]

Sorry, I'm getting my C and Perl mixed-up. That should of course have been:
[tt]
@lt=localtime(time);
$datestring=
sprintf
(
"%d%02d%02d%02d%02d",
$lt[5]+1900,$lt[4]+1,$lt[3],$lt[2],$lt[1]
);
[/tt]

 

[andrewxie]

thanks all of you.