I'm wondering there's a simpler was to achieve this w/o need to jump
through a couple of hoops. (meaning, concatenate the fields together
from extract or some other method)
Timestamp : '2008-01-17 10:24:00'
Output needed : 20080103 or even 200801w3
In postgresql, this is done via
select to_char('2008-01-17'::timestamp,'YYYYMM')|| 'w' ||
to_char('2008-01-17'::timestamp,'w')
result : "200801w3"
Trying to do some perl-DBI and directly inserting the results into specific
partitioned tables.
--
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
http://learn.perl.org/
