471,887 Members | 1,435 Online
Bytes | Software Development & Data Engineering Community
Post +

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 471,887 software developers and data experts.

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 4891

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 YellowAndGreen | last post: by
reply views Thread by zermasroor | last post: by

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.