I'm using mysql for my db.

I have a question here but i'm not with putting it into proper sentences, so here's the example of what i wanna do.

table: TableA
field: myDatetime >>> datatype: datetime

is it possible to query this table but with the myDatetime field displayed as "yyyy-MM-dd" instead of the datetime format
"yyyy-MM-dd hh:mm:ss"?

Thanks people.

Hi Krashed

Here is your solution...

The table is
mysql> desc mytab;
+------------+----------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+------------+----------+------+-----+---------+-------+
| mydatetime | datetime | YES | | NULL | |
+------------+----------+------+-----+---------+-------+
1 row in set (0.00 sec)

mysql> select * from mytab;
+---------------------+
| mydatetime |
+---------------------+
| 2006-04-05 10:22:15 |
+---------------------+
1 row in set (0.03 sec)


mysql> select date_format(mydatetime,'%Y-%m-%d') from mytab;
+------------------------------------+
| date_format(mydatetime,'%Y-%m-%d') |
+------------------------------------+
| 2006-04-05 |
+------------------------------------+
1 row in set (0.00 sec)

Best Regards
Milind