in reply to Coolest way to decode YYYYMMDD?
Why all the contortions? Keep it simple and talk to your database:
$ echo "select to_char(to_date('19830501?','YYYYMMDD'), 'FMMon FMdd, y +yyy?')" \ | perl -MDBI -ne ' print DBI->connect("dbi:Pg:")->selectall_arrayref($_)->[0]->[0], + "\n"; '; May 1, 1983?
;-)
P.S. (Looks I am the first one to spot the terminal question mark in your example? Does that get me Mega-XP too?)
|
|---|
| Replies are listed 'Best First'. | |
|---|---|
|
Re^2: Coolest way to decode YYYYMMDD?
by hdb (Monsignor) on Jun 03, 2013 at 16:56 UTC | |
|
Re^2: Coolest way to decode YYYYMMDD?
by Your Mother (Archbishop) on Jun 03, 2013 at 13:48 UTC | |
by jdporter (Paladin) on Jun 05, 2013 at 04:56 UTC | |
by Your Mother (Archbishop) on Jun 05, 2013 at 13:34 UTC | |
by jdporter (Paladin) on Jun 06, 2013 at 02:59 UTC |