> > If your DateStyle is set to ISO that's the default format. You don't need > to use to_char() > > Or am I missing your point? >
Hi Richard, I'd just like to format it independent of my DateStyle. Some timestamp parts may be formatted this way. For instance I can format ISO date with to_char( dt, 'YYYY-MM-DD'), and ISO time with to_char( dt, 'HH24:MI:SS') as well. I'd just like to find the format pattern for the ISO time zone (numeric). Regards, Sabin ---------------------------(end of broadcast)--------------------------- TIP 1: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly