posted 11 years ago
Thanks for your reply R. Jain and James Boswell,
Actually i did mistake, i write sql query as,
and use this code to take data from resultset.
So, my mistake is, i forget to gave column name after DATE_FORMAT(date,'%Y-%m-%d %h:%i:%p'),
When i use sql query,
and use below code to fetch data from resultset,
I am getting values in table like,
2012-08-17 10:53:AM
Once again thanks for showing interest R. Jain and James Boswell..... :-)