mysql in General :: Programming

perl
mysql (3)
perl CGI (3)

How to work mysql from perl. This site is mainly built with mysql and perl (and some php)

Articles:

This list is sorted by recent document popularity (not total page views).
New documents will first appear at the bottom.

Featured Article

Convert a date from Apache's string format to mysql's date format in perl

Question:

Apache logs dates in this form: [25/Apr/2005:11:45:59 -0400] and I need to insert this string in a mysql table as a datetime value.
How can I convert it?

Answer:

mysql has powerful date handling functions, which unfortunately vary from version to version substantially.
You may use the following perl code instead - it converts

25/Apr/2005:11:45:59

to

2005-04-25 11:45:59

%mo = (
  'Jan'=>'01',
  'Feb'=>'02',
  'Mar'=>'03',
  'Apr'=>'04',
  'May'=>'05',
  'Jun'=>'06',
  'Jul'=>'07',
  'Aug'=>'08',
  'Sep'=>'09',
  'Oct'=>'10',
  'Nov'=>'11',
  'Dec'=>'12');
 
 $time = substr($time,7,4) . '-' . $mo{substr($time,3,3)} . '-' . substr($time,0,2) . ' ' . substr($time,12);

Most recent comments

2008-05-13 19:43:38:
by Dirk
in Dating Scams
on Dating scammer Ekaterina Rozhentsova:
Jose Tapia Soy,

Usted está en la angustia. Entiendo por qué su corazón duele. Déjele ir. Deje a su mosca a las estrellas. Ella quiere volar. Deje a su mosca de corazón otra dirección. E ... read more

2008-05-13 19:31:08:
by KJ
in Dating Scams
on Dating scammer Goodwill Ajaratu:

Uses stolen pictures.

2008-05-13 19:27:38:
by [hidden]
in Real Estate
on What happens to the second mortgage in a short sale?:
Question 1 concerning the bankruptcy.

You might be asking the wrong questions. The reason why no one can give you a quick answer is because there are many possible outcomes after the BK is d ... read more

2008-05-13 19:21:02:
by anonymous
in Dating Scams
on Dating scammer Lyudmila from Irkutsk, Russia:

she is a beautiful girl that looks very pampered but says that she is poor girl who can't fly bacause she needs your money to be pampered with lol!!!!!! you should always stick with your local dating ... read more

2008-05-13 19:05:24:
by anonymous
in Dating Scams
on Dating scammer victoria atinga:

heres some more photos and she also is friends with amira sal (aka) mslove@yahoo.com

2008-05-13 18:57:47:
by Dirk
in Dating Scams
on Dating scammer Anastasiya from Medvedevo:
Vianen,

Je kunt me bereiken op djvandellen@home.nl

Stuur maar eens wat info. Dan kijken we er samen even naar. Maar... Niet meteen mijn box volplempen! Laat nog wat ruimte voor de 'm ... read more

2008-05-13 18:56:23:
by anonymous
in Dating Scams
on Dating scammer Yuliya Bechneva:
she also goes by the name of Nataliya Boijko, also asking for money for visa

2008-05-13 18:56:05:
by anonymous
in Dating Scams
on Dating scammer Anna Zelen:
TE SIGO BUSCANDO Y CADA VEZ MAS LEJOS TE ENCUENTRO
EL AMOR EL AMOR

TUS OJOS ME ATRAEN COMO EL IMAN AL HIERRO SOLO ESO CREO....

2008-05-13 18:43:03:
by [hidden]
in Dating Scams
on Dating scammer Pittstop Raceway:

This man is fraud...he is in Nigeria. Working with African material so he says,..asking from me the American Woman, to open account and he will place funds into my account. He is also abusive, if you ... read more

2008-05-13 18:23:45:
by Dirk
in Dating Scams
on Is this Russian girl scamming me? How to recognize scammers:
Anon France,

Nous avons besoin de plus d'informations identifier la fille ou établir si vous vous occupez d'un scammer. S'il vous plaît, continuez correspondre à Marina non avant que vous ... read more


	Search: