# SQL Date / Datetime convert?

**URL:** https://forum.kirupa.com/t/sql-date-datetime-convert/236933
**Category:** programming
**Created:** [August 25, 2007, 2:51am UTC](https://forum.kirupa.com/t/sql-date-datetime-convert/236933 "2007-08-25T02:51:39Z")
**Posts on this page:** 1
**Page:** 1

<div class="post-metadata">

### Author: ![siuj](https://avatars.discourse-cdn.com/v4/letter/s/e0b2c6/32.png) [@siuj](https://forum.kirupa.com/u/siuj)
#### Post date: [August 25, 2007, 2:51am UTC](https://forum.kirupa.com/t/sql-date-datetime-convert/236933/1 "2007-08-25T02:51:39Z")

</div>

Hi,

How can I write a query to sum up the amount group by date (not datetime) of the following data?

MyDate / Amount  
2007-08-15 16:13:21 / 2500  
2007-08-15 16:14:24 / 5000  
2007-08-18 10:19:00 / 1000  
2007-08-18 10:19:04 / 12000

Thanks! 🙂

Of course, this query is NOT works…

```auto
SELECT date, sum(amount) FROM mytable GROUP BY date;

```

I have tried to use Convert …  
but seems there exists an error… ☹

```auto
 
select convert(varchar(20), MyDate, 101) from mytable;

```