Hello,

I am having problems formatting a date that I select from my oracle database. The field is an oracle DATE field. I want to display it as MM/DD/YY. I have tried:

<dtml-in sql_get_invc_date>

<dtml-var invc_date fmt="%m/%d/%y">

</dtml-in>

The formatting works fine when I use ZopeTime but not when I use a dtml-var.

I appreciate your help.

Thanks.

Mike Guerrero