[SQL] getting the current date

[Joseph Syjuco]

how can i get the current date (without the time part) in sql.  I tried
doing a select now() but it also gives me the time part 
TIA
joseph




---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster