Datetype field conversion to YYMMDDHH24MISS

[jschoono]

Hi there,

I need to convert a date type field into following format: yymmddhh24miss.

Is there a similar function like TO_CHAR(table.datefield,'YYMMDDHH24MISS') i use for the conversion on an oracle database?

Thanks for your help,
Cheers

[numberwhun]

Hi there,

I need to convert a date type field into following format: yymmddhh24miss.

Is there a similar function like TO_CHAR(table.datefield,'YYMMDDHH24MISS') i use for the conversion on an oracle database?

Thanks for your help,
Cheers

That's nice, but you failed to mention the language that you are working in. We are not mind readers you know.


Regards,

Jeff

[jschoono]

That's nice, but you failed to mention the language that you are working in. We are not mind readers you know.


Regards,

Jeff

Hi Jeff,

That's the whole point. I need something generic that takes this in account ;-)

Thanks for the reply,
Jacques

[jschoono]

Hi all,

In the meanwhile i got a working solution, but should anyone have comments or a better solution, posting will be much appreciated :-) I am not sure if this is generic enough to be used in the various regions.

CONVERT(varchar(6),<myDateTimefield>,12)+REPLACE(C ONVERT(varchar(12),<myDateTimefield>,114),':','')

Cheers,
Jacques

[pbmods]

Heya, Jschoono.

Are you looking for DATE_FORMAT()?