SELECT STRTODATE('20100212 103545', '%Y%m%d %h%i%s') As New_form; this is still giving null values..help to rectify it