Hopefully someone will have a quick answer for this question, because I'm in the middle of a time critical project and this is a stumbling block.
Here is what it is...
I have a temp_transaction table (mysql) that has various fields, one of which is a trans_date (datetime) field.
When I query the table, and assign the values to variables, the trans_date field displays just fine with the date and time.
But the next thing I want to do is to create a new record for a perm_transaction table.
When I create the insert statement using the variables that were assigned with the values from the query, and print out the insert statement, the values for the trans_date field are all zeros..
Any suggestions on why that might be, and how to correct it?
Thanks in advance.
I'm in a real time crunch here, so any help would be greatly appreciated.