I have a date field in my SQL database as dd/mm/yyyy but I want it the"/"s removed. I would like to have a date field as ddmmyyyy. Is that possible?
I want another field to have time as HH:MM:SS but that should be the present time.
Would someone please tell me how to do it?
Many thanks in advance
I want another field to have time as HH:MM:SS but that should be the present time.
Would someone please tell me how to do it?
Many thanks in advance