I have a DATE field and a separate char field which contains time in hhmiss format. How can I create a timestamp field from these 2 fields?
Can anybody help me?
Try timestamp#(DATE & ' ' & CHAR, 'DD/MM/YYYY hhmmss').
I don't know what you date format is so verify that DD/MM/YYYY correspondes with date format in column DATE. Replace CHAR with the name of the column iwth the time.
Retrieving data ...