Manipulation with DB2 dates times and timestamps

1 post / 0 new
Anonymous
Manipulation with DB2 dates times and timestamps

 

 

 

Hello All,

There are a variety of manipulations that we can do with DB2 date, time and timestamp function.  

Often we are in a situation where we need to change the format of a date or calculate the difference between two dates, or compare dates etc etc,  DB2 offers a plenty of functions for doing this all at one go. 

Some of the examples are

DAYS 

DAYOFWEEK

JULIAN_DAY

TIMESTAMPDIFF

TO_DATE

TO_CHAR

I found one really good article on "DB2 Basics: Fun with Date and Times"

You will certainly enjoy this article and it will be really useful.

Now I would leave up to you to use these date and time functions with a pinch of your creativity, how about using this functions in your COBOL DB2 program... do you think this will work?

Explore on your own and yeah share with everyone if you succeed.

Regards!!

Vikas

"; ; ; ;
Sponsored Listing