String to date convertion 1

[Fampofo]

Dear guys. I am trying to covert a string to date format. this field is suppose to be a date field but it is a char.
this is what I did.....

to_date(max(date_last_seen)last_att

values in the field are eg. 01/02/05
this is the error msg I get "ORA-01843: not a valid month"
can anyone help. thanks

 

[lewisp]

[tt]To_Date(max(date_last_seen),'DD/MM/YY')[/tt] should do it, but can you be sure the format is always dd/mm/yy?

The reason you are getting 'not a valid month' is likely to be that your default data format is something like DD-MON-YYYY, according to your NLS date settings.

 

[Fampofo]

Thanks I have got it working now..
frank