weekday info?

How can I use sqlplus to get weekday info from
a date value? I tried sth like
select weekday(event_date) from events;
It doesnot work, saying "invalid column name"

Thanks.
xz02Asked:
Who is Participating?
 
sudhi022299Connect With a Mentor Commented:
you have to use to_char function for that
select to_char(sysdate,'D') from dual;
This would give you day of the week.

need more info, post a comment

Regards,
Sudhi.
0
 
xz02Author Commented:
It worked. Do you know how to do
the same thing for infomix database?

Thanks.
0
 
sudhi022299Commented:
Sorry i don't know informix.
I'm sure that there should be some date function like this.
Post a question in the Informix area.

Regards,
Sudhi.
0
All Courses

From novice to tech pro — start learning today.