Clicky
Skip to Content
Custom Search

Reply to comment

Anonymous

 

 

 

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

Reply

  • Allowed HTML tags:
      1. Lines and paragraphs break automatically.

    More information about formatting options

    CAPTCHA
    This question is for testing whether you are a human visitor and to prevent automated spam submissions.

Navigation

Click the +1 button  below to share it with your friends and colleagues

 

Share this if you liked it!

 

Disclaimer



Number of Registered users 714
Theme by Dr. Radut.