Date Formatting

[Guest_imported]

Hi,

Could anyone help me with this?

In Access, this works fine...
SELECT Format(create_date, 'mm/dd/yyyy')
FROM db2inst1_proj;

But in db2, the above statement does not work.

Thanks,

Naveen

 

[carpeliam]

this might be more appropriate in a db2 forum. <p>Liam Morley<br><A HREF="mailto:"></A><br>&quot;light the deep, and bring silence to the world.<br>light the world, and bring depth to the silence.&quot;