EZT -> get weekday from system date

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

i want to get week day or week number from a system date in MM/DD/YY format thru easytrieve. Please let me know ASAP if any one has any idea about it.

guptae · Posted: Wed Mar 21, 2007 10:29 am

Hi Gprerna,

You can use following query in your ezt pgm

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

can we code SQL's in a ezt?

dick scherrer · Posted: Thu Mar 22, 2007 3:41 am

Hello,

Yes, if your shop has DB2 and you have access to it.

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

Can we convert system date into week day or week number without using SQL?

dick scherrer · Posted: Thu Mar 22, 2007 3:46 am

Hello,

You could write code to do this . . . Instead, i'd suggest you talk with others at your location and see if there is already a callable module you could use.

If you have this requirement, others have most likely had to do the same thing previously.

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

No we dont have access to it

Do you have any idea how i can do it?

William Thompson · Posted: Thu Mar 22, 2007 4:18 am

gprerna · New User Joined: 21 Mar 2007 Posts: 38 Location: US

I mean, how can i convert date to week day or a week number with using SQL.

dick scherrer · Posted: Thu Mar 22, 2007 6:12 am

Hello,

You can get the "week" or the "dayofweek" (or a whole bunch of other date/time values) using the suggestion Ekta posted in response to your original query.