-STR_TO_DATE help

[Ben Stanton]

Is there anyway to use STR_TO_DATE against a field?

Here's a query that works for me
SELECT STR_TO_DATE('(5/18/2009 9:34:58 AM)', '(%c/%e/%Y %r)') AS NewDateTime;

It will return
2009-05-18 09:34:58

But instead of having to input '(5/18/2009 9:34:58 AM)' in the SELECT statement, is there anyway I can use a field to act as the input?

This query does not work :(

SELECT STR_TO_DATE(OS_INSTALLED_DATE, '(%c/%e/%Y %r)') AS NewDateTime
from ORG1.MACHINE

I need the text in the field "OS_INSTALLED_DATE" into a date-friendly field, "NewDateTime".

Ideas?



Edited 1 time(s). Last edit at 07/20/2011 02:11PM by Guelphdad Lake.