Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- select db||sysdate
- (this is the component where I want only 08 from the date)
- from gct;
- to_char(sysdate, 'YY')
- extract(YEAR FROM DATE '2008-12-24')
- mod(extract(YEAR FROM DATE '2008-12-24'), 100)
- select db||to_char(sysdate,'YY')
- from gct;
Add Comment
Please, Sign In to add comment