uShop English (U.S.) for 179!

uStorekeeper English (U.S.) for 149!

 Products
       uTest
       uReserve
       uShop
       uStorekeeper
       uGolf
       uDirectory
       uSignIn
 Tech Support
       Support Policy
       Knowledge Base
            uTest
            uReserve
            uShop
            uStorekeeper
            uGolf
            uDirectory
            uSignIn
       Documentation
       Reference Sites
 Legal
       Software Piracy
       Legal Notices
       Privacy Policy
       Licensing
 Miscellaneous
       Reseller Info
       Contact Us
       Site Map
Format of $order_date?

Knowledge Base Lobby : uShop Support Conference : Programmer Tips
Oct-24-17 12:08 AM EST
Original Message
Format of $order_date?
Author Brian Levine on 08-07-2002 at 10:18 (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'.
TABLE OF CONTENTS

Table Of Contents
  RE: Format of $order_date? Bill Weiner, 2002-08-08 04:47:44 (1)
            $order_date format Brian Levine, 2002-08-08 11:04:01 (2)
                 RE: $order_date format Bill Weiner, 2002-08-09 04:02:30 (3)

Messages In This Discussion
         1. RE: Format of $order_date?
        Author Bill Weiner on 08-08-2002 at 04:47 (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.
TABLE OF CONTENTS
                 2. $order_date format
                Author Brian Levine on 08-08-2002 at 11:04 (EST)
Thanks. Looks like MySQL wanted the date in YYYYMMDD format, so I used substr() to reformat it and it works fine.
TABLE OF CONTENTS
                         3. RE: $order_date format
                        Author Bill Weiner on 08-09-2002 at 04:02 (EST)
cool
TABLE OF CONTENTS

© 2003 Microburst Technologies, Inc.