www.uburst.com www.uburst.com

"Format of $order_date?"

Go back to the LobbyClick here to Go Back to Main ListingClick here to see helpClick here to Search the Forum

Programmer Tips
Forum Type: Public
Moderator: edmunds
Time Zone: EST
Printer Friendly Format
Original Message
 
"Format of $order_date?"
Posted by Brian Levine on Aug-07-02 at 10:18 AM (EST)
What is the format of the global $order_date in ushop.pl? When I write it out to a date field in my database, it comes up '2008-06-20' for the date '2002-08-06'.
Click to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents

 Table of Contents

RE: Format of $order_date?, Bill Weiner, Aug-08-02, (1)
$order_date format, Brian Levine, Aug-08-02, (2)
RE: $order_date format, Bill Weiner, Aug-09-02, (3)

 

 
Click here to goto Click here to goto the Lobby
Messages in this discussion
 
1 . "RE: Format of $order_date?"
Posted by Bill Weiner on Aug-08-02 at 04:47 AM (EST)
The format of the date is dependent on the $date_format setting at the top of the ushop-lib.pl file:

$date_format = 1; # 1 = MM/DD/YYYY, 2 = DD/MM/YYYY

So make sure your database is expecting that format.

Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
2 . "$order_date format"
Posted by Brian Levine on Aug-08-02 at 11:04 AM (EST)
Thanks. Looks like MySQL wanted the date in YYYYMMDD format, so I used substr() to reformat it and it works fine.
Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick to EMail Click here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents
 
3 . "RE: $order_date format"
Posted by Bill Weiner on Aug-09-02 at 04:02 AM (EST)
cool
Remove this Message: Administrator and Moderator onlyClick to Send Alert Message to the Administrator Click to edit this messageClick here to reply to this messageClick here to reply to this message with quotesClick to goto the Table of Contents


Archive This Thread: Admin and Moderator OnlyRemove This Thread: Admin and Moderator Only
Click here to goto Click here to goto the Lobby

 

 

 

 

 

 

 

 

 

 

 

 
Questions or problems regarding this bulletin board should be directed to Webmaster
©1997-1999 by DCScripts. All rights reserved.