i've created this table: create table schedule ( day date, tm timestamp, room char(4)); insert into schedule values ('20/06/2001','08:00:00','A104'); my problem is how to get day of week information from date or is there any way to do this? would you show me how to do it? thank's Didi ---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives? http://www.postgresql.org/search.mpl