469,579 Members | 1,102 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,579 developers. It's quick & easy.

Setting date format on EXPORT / conversion of date to timestamp

Looking at the documentation on EXPORT, when exporting a date column
it will automatically use yyyymmdd. One could choose to use ISO
format, but unfortunately the client I'm exporting to can't deal with
this and will only accept dd/mm/yyyy.

Undaunted, I find that one can set the format when exporting a
timestamp. So I thought of casting the date to a timestamp and then
exporting with timestamp format set to dd/mm/yyyy. But one isn't able
to cast date to timestamp.

What way can I get around this? Cast the date to something else first
and then cast it to timestamp? Or should I just give up and do
something like day(datefield) || '/' || month(datefield) || '/' ||
year(datefield) ?

[DB2 8.1.2 on Suse]
Nov 12 '05 #1
0 4727

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Ben | last post: by
3 posts views Thread by praba kar | last post: by
2 posts views Thread by Jitender Kumar C | last post: by
2 posts views Thread by johndcal | last post: by
11 posts views Thread by shsandeep | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.