I simply want to put the system date in a field in a table.
The field IS DEFINETLY set up as a date data type.
However, the table designer will not allow more than 8 characters for this type of field.
I use:
REPLACE dsjn.req_date WITH date()
The code kicks back with a 'data type mismatch' error.
I've tried 'SET CENTURY OFF' no, avail...any suggestions?
Thanks in advance!
Bob Ross ( A confused newbie )
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only