I use the below sql statement to add one day to the date select DATEADD(day,1,'2003-08-11 23:59:59') as datered
It returns $expir="Aug 12 2003 11:59PM" To convert the format to YYYY-MM-DD I use $expir=date('Y-m-d', $expir); The new value returned is 1969-12-31. What am i doing wrong. The only thing I want to do is convert my date to a YYYY-MM-DD format. Please help. Thanks, Harpreet -- PHP Windows Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php