mysql - Getting MM field extra in my date -


i developing small application,in fetching data date in format yyyy:mm:dd hh:mm:ss.mm in data base date field has stored in format yyyy:mm:dd hh:mm:ss can 1 tell me why getting mm thing

mm miscrosecond part of datetime datatype.

microsecond introduced in mysql version 5.6.4 .

the microsecond part introduced if during table creation datatype specified as

datetime(fractional_part) 

see mysql documentation

you should define date field datetime(2) microseconds


Comments

Popular posts from this blog

blackberry 10 - how to add multiple markers on the google map just by url? -

php - guestbook returning database data to flash -

delphi - Dynamic file type icon -