I know this was discussed, but being a coder, what do I add to the format script to format a date column to mm/dd/yyyy? Just an example of the code would help. Thanks.

Hello Doug,

Which is your server side language? ASP or PHP?

Regards,

PHP

I should have said in the first post that I am NOT a coder, but with some samples I can usually do some coding. I am working in PHP and just need a sample of setting a format up for a date format mm/dd/yyyy. Thank you.

Any change I can get a sample of PHP format for dates in MYSQL format (yyyy-mm-dd). Thank you.

Any change I can get a sample of PHP format for dates in MYSQL format (yyyy-mm-dd). Thank you.

Hello Toby.

Which version of PHP you are using ?

Regards: Vulcho.

PHP Version 5.1.6

This example uses PHP, which has two extremely useful built-in functions for dealing with dates and times: strtotime() and date().

1	$res = mysql_query('SELECT datefield FROM tablename WHERE foo = "bar"');
2	$row = mysql_fetch_array($res);
3	print date('d M Y', strtotime($row['datefield']));

The strtotime() function is used to parse the date and time returned from the MySQL query into a UNIX timestamp. The date() function then formats that returned timestamp into 'd M Y' format, which is the day of the month with a leading zero, followed by the short month name (eg 'Jan', 'Feb', 'Mar') then a 4 digit year.

Hi Vulcho,

This sounds like what I need but how do I implement this to be used on a datagrid using a recordset?

Thanks

Pete

I solved this with a view using a "complex" SQL statement which formats the date