Convert non-timestamp date into readable

[knippysing]

I am trying to convert a date YYYY-MM-DD HH:MM:SS to MM/DD/YY if at all possible. I know how to convert timestamps but can't figure out how to convert the above.

Does any one know of anything easy here? I have done my homework and going nuts because I can't find anything that will work with a non-system-generated date.

TIA

[coopster]

YYYY-MM-DD HH:MM:SS

is a timestamp. If it is defined in your database as a column type of the same you can use either the database-specific Date and Time Functions or you can use standard SQL syntax to reformat the date. If it is not defined as such you should still be able to format that string as desired.