Example of To_Char function in sql

Example of To_Char function in sql

By following example we could know how to use to_char function in sql select query.

To get number of student who registered on particular date.

Select Stdname ,to_char(regdate ,'day') day from student where to_char(regdate ,'day')='saturday' or to_char(regdate ,'day')='monday';