On Tue, 23 May 2000, Philip Hallstrom wrote:
> Hi -
> I'm playing around with inserting dates into a timestamp field and
> am getting annoyed at single digit dates/days/hours/minutes.
> The problem is that I have something like:
> TO_TIMESTAMP('2000 5 25 09 30', 'YYYY MM DD HH24 MI')
If I good understand you:
test=# select TO_TIMESTAMP('2000 5 25 09 30', 'YYYY FMMM DD HH24 MI');
to_timestamp
------------------------
2000-05-25 09:30:00+02
The 'FM' (fill-mode) is a local option and is always used for next element.
In your example for 'MM'. Without 'FM' formatter expect full number.
Karel