Select Code to Download

#create Session table.
$sql_line = "create table Session (...date DATETIME NOT NULL, ... )";
#create Order table.
$sql_line = "create table Orders (...order_date DATE NOT NULL, ...)";

### This is useful for converting epoch seconds
use Time::localtime; 
...
        $session{$currentsession}[6] = $formatteddate;
    }
}

###stuff from the hash can now be inserted, as is, into mySQL
    print SQL "insert into Orders (..., order_date,...)";
    print SQL "values (...,'$order_date', ...);\n";