Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
amurark
Yak Posting Veteran
55 Posts |
 Posted - 2011-12-27 : 11:19:45
|
| As we know the default date and time format in mysql is "yyyy/mm/dd hh:mm:ss".But how to change this suppose: Monday @ 12:19Am, December 4thanksankitaAnkita |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-12-27 : 12:05:18
|
| This forum is specific to Microsoft SQL Server, so while there may be a few people who are familiar with mysql, you are likely to get better and faster responses at a mysql forum or generalized database forums such as dbforums.com |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-28 : 00:59:09
|
quote:
Originally posted by amurark
As we know the default date and time format in mysql is "yyyy/mm/dd hh:mm:ss".But how to change this suppose: Monday @ 12:19Am, December 4thanksankitaAnkita
from generic db perspective you shouldnt be worried at how dates are stored in your databse and their format. Formatting is something you need to worry and deal at your front end application. Whatever format db stores them, There are date functions available in all application languages to change them in the format you want for displaying at front end.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
query