Hi, In mysql I'm using current time stamp to store date. this is the format stored 2010-11-14 03:40:56. Now I'm fetching this as it is. Can I change this format while fetching?
There are a couple of functions you can: GET_FORMAT DATE_FORMAT There are other functions to only get the day, year or month. Check the whole list of date functions in MySQL: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html
i dont think that is possible. I was also wondering once how to do that but couldn't find anything of that sort. So i created a parser for that. but the parser i created was for a date field. i would suggest you do that too. i would suggest you should write a function which retrurns each and every individual integral value (like day, month, year, hour, minute, etc.) in one array so that you can format it and use it as you want.
Thank you, I will try it. function which retrurns each and every individual integral value (like day, month, year, hour, minute, etc.) in one array so that you can format it and use it as you want.