var sidebar_align = 'right';
var content_container_margin = parseInt('350px');
var sidebar_width = parseInt('330px');
Changing the view of the database date?
I have a database with a table including blog entries and a date the date is set to year-month-day format, How can i change it to something else, as i tried to change it to day-month-year so it will look like 11 September 2009 for example
http://dev.mysql.com/doc/refman/5.1/...functions.html, or the appropriate documentation for your unnamed database.
You can use like this
select date_format(date, '%d %M %Y') as formatted_date from table_name;
Where date is the name of your date field, and formatted_date is a variable name which you can use to retrieve the value.
By prashant1979 in forum Hosting Security and Technology
Last Post: 11-08-2007, 12:58 PM
By activeco in forum VPS Hosting
Last Post: 08-29-2007, 03:02 AM
By CCF Hosting in forum Running a Web Hosting Business
Last Post: 09-07-2004, 11:10 AM
By hdezela in forum Programming Discussion
Last Post: 09-06-2003, 01:54 PM
By Eiv in forum Hosting Security and Technology
Last Post: 01-22-2002, 04:22 AM