How to convert ddmmyy into SQL datetime
Posted on 2008-11-13
I have an IVR which takes in DTMF values for a date in the format ddmmyy.
I then want to update a date field with those values - how do I go about convert the string into a datetime field? I'm finding I can't use Convert(Datetime.... because it is expecting the input in a different format.
Likewise if I take in, for example, 1450 to represent a time, how do I get that into a table field to log the time?
Thanks in advance....