Page 1 of 1

How to find the day of the Date ?

PostPosted: Mon Jul 08, 2013 11:58 am
by bobbysiddu
Hi all,
I want to write a PL/I program on how to find the "day of the date".
I know how to fetch the date from the system date.
But I want to know is there any function to convert the date's day(number) into day of the week.
Please guide me on building the logic.

Any help would be appreciated.

Thank you,
Siddu

Re: How to find the day of the Date ?

PostPosted: Mon Jul 08, 2013 12:14 pm
by Stefan
SELECT                                                   
  CASE                                                   
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 1 THEN 'SUNDAY'   
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 2 THEN 'MONDAY'   
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 3 THEN 'TUESDAY' 
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 4 THEN 'WEDNESDAY'
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 5 THEN 'THURSDAY'
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 6 THEN 'FRIDAY'   
    ELSE                                       'SATURDAY'
  END                                                     
FROM SYSIBM.SYSDUMMY1;                                   

Re: How to find the day of the Date ?

PostPosted: Mon Jul 08, 2013 2:13 pm
by bobbysiddu
Thank you Stefan... :-)

Re: How to find the day of the Date ?

PostPosted: Mon Jul 08, 2013 3:08 pm
by Akatsukami
Stefan wrote:
SELECT                                                   
  CASE                                                   
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 1 THEN 'SUNDAY'   
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 2 THEN 'MONDAY'   
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 3 THEN 'TUESDAY' 
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 4 THEN 'WEDNESDAY'
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 5 THEN 'THURSDAY'
    WHEN DAYOFWEEK(CURRENT TIMESTAMP) = 6 THEN 'FRIDAY'   
    ELSE                                       'SATURDAY'
  END                                                     
FROM SYSIBM.SYSDUMMY1;                                   

Is that not rather a SQL solution than a PL/I one?
dcl dayofweek char (90;
select (weekday());
  when (1) dayofweek = 'Sunday';
  when (2) dayofweek = 'Monday';
  when (3) dayofweek = 'Tuesday';
  when (4) dayofweek = 'Wednesday';
  when (5) dayofweek = 'Thursday';
  when (6) dayofweek = 'Friday';
  when (7) dayofweek = 'Saturday';
end

Re: How to find the day of the Date ?

PostPosted: Mon Jul 08, 2013 6:17 pm
by bobbysiddu
Yes.
I executed the code..
It does look like a SQL code.
Will try with other logic(mentioned by Akatsukami) and reply..
Thank you.