Answer by
knightmare (1231)
If I understand correctly, you'll need the to_date function. Here's the syntax: to_date('01/01/2001', 'MM/DD/YYYY'). You need a format mask after the comma for it to work. You can use different kinds of format masks as well, such as to_date('01-01-01', 'MM-DD-YY') and many others. These cna be found online. Good luck!