how can i extract date from datetime

[sharad]

hi sir
i m using vicidial.i have a CRM project in which i can access the asterisk database.but i have a problem in accessing some records

like..........

in the vicidial_agent_log table event_time fields datatype formate is like that
2006-09-15 00:00:00 but that formate not supported by VB.NET.
so how i can access only date from this.

i was trying with changing datatype DATETIME to DATE.but by query it takes default time 12:00 AM automatically.

can u have some guidence ,about that how can i extract only date from datetime

thankyou

[mflorell]

Take a look at the mysql documentation:
http://dev.mysql.com/doc/refman/5.0/en/ ... tions.html

You can format datetime fields in just about any way you want.

I am still amazed how inflexible Microsoft makes even their programming languages when it comes to things like this.