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