how to fetch system date in db2 with syntax

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

can anybody tell me how to fetch system date in db2 with syntax.

thanx in advance
regards...
manjinder

ofer71 · Posted: Tue Jan 17, 2006 10:28 am

Hi -

CURRENT_DATE is a DB2 special register, and is well documented (with example) in the fine manual.

O.

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

what should be there in insert query for fetching system date.
thanx in advance.
regards..
manjinder

ofer71 · Posted: Tue Jan 17, 2006 10:41 am

As you can see in the fine manual, when you CREATE a table you can define the column as DATE type. If you specify "WITH DEFAULT" for that column, its default will be CURRENT DATE when you insert new row.

O.

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

thanx alott ofer it is wrking i am able to fetch system date and system timestamp.
thanx alottt for your help..
regards..
manjinder

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

please let me know the differences between alias,synonym and view
and tell me why we drop only views not synonym and alias because they dont take memory space or what?
thanx in advance.
regards...
manjinder

manjinder · New User Joined: 04 Dec 2005 Posts: 45 Location: pune

please let me know the differences between alias,synonym and view
and tell me why we drop only views not synonym and alias because they dont take memory space or what?
thanx in advance.
regards...
manjinder

ofer71 · Posted: Tue Jan 17, 2006 11:24 am

Here are the definitions from the fine manual:
- Alias
- View
- Synonum

You can DROP alias, view or synonym, according to the manual.

O.