Wednesday, October 03, 2007

Convert a stats input date to Edward date_sid

Old way of doing it:
select to_char(to_date('09/01/2007', 'MM/DD/YYYY'), 'YYYYMMDD') from dual;

New way with regexp
select regexp_replace('09/01/2007', '(\d{2})/(\d{2})/(\d{4})', '\3\2\1') from dual

reduced function call to 1

2 comments:

Unknown said...

Okay, this won't help you unless you work at YSM! ;)

Anonymous said...

Seeing as it is a program for newbies, it is extremely user-friendly and the training curve type of|is sort of} steady. Features like the customisable hotkeys and easy to use interface are indicative of its standing as a super tool for starters. A parametric 3D modeling tool that's open-source and lets you high precision machining design real-life objects of any measurement. The parametric component makes enhancing your design a piece of cake. Simply go to your model history and alter the parameters, and you’ll have a unique model.