Very Computer

1. Date Time format to Date format

Hi All,
I havea field logtime with datetime datatype. I would like to remove
the time part and then group by date, however whether i remove the
time part or not, i get the same results. I m givng the code below to
convert the date, can anyone plz help? many thanks
select convert(datetime,Convert(varchar(10),logtime,102)),totals from
total t INNER JOIN log t ON blah blah group BY
convert(datetime,Convert(varchar(10),logtime,102)),totals

thanks
ben

2. INTERNATIONAL WEB SERVICES CONFERENCE & EXPO!

3. Dates Format: Trouble giulian format (long numeric value)

4. UNLOAD TO filename causes ONLINE crash

5. Date Formats in Tables (Wrong International Format)

6. I'm Looking for an Accounting VBX, or OCX

7. Converting Unix Date/time format into SQL readable format

8. How to retrieve constraints information

9. Formatting the date format without doing it in the cinnection string

10. Extracting date formats from a date

11. Days +Date into Date Format

12. How to convert US date to Intl date format

13. SP : String to Date/ Database Date Format?