How do get day name as monday or saturday

need to know how do get name of day like Sunday or Monday

Hey there, you can try this:

SELECT TO_CHAR(CURRENT_DATE(), 'DAY')

thank you so much it is working

1 Like