need query hw to select last 3month,3 week, only friday only sysdate using dual table

karuppiah

Hi All,
i need query,how to select last 3 month ,last 3wek,last 3 days , this last 3 month and 3 week should be friday, using sysdate from dual table, there is no exsting table, pls any one help me.

Regards,

karuppiah.

debasisdas

you need to play with TO_CHAR function.

need query hw to select last 3month,3 week, only friday only sysdate using dual table

re: need query hw to select last 3month,3 week, only friday only sysdate using dual table

Similar Oracle Database bytes

/bytes/development

/bytes/it

/bytes/about