seagull
-
Posts
1 -
Joined
-
Last visited
Never
Everything posted by seagull
-
in my MSSQL tables the date is in the format of yyyy-mm-dd hh:mm:ss. I am trying to get a report in the format: Date Total Minutes 2006-Mar-1 1100 2006-Mar-2 5004 2006-Mar-3 8000 and so on. The group by DATE dont give the required output as the TIME also is in the DATE column. Any ideas are appreciated