Re: Date format problem
From: Dirk Bellemans <Dirk.Bellemans_at_skynet.belgium>
Date: Mon, 11 Oct 1999 21:23:07 +0200
Message-ID: <7ttdm8$eoa$3_at_news0.skynet.be>
Date: Mon, 11 Oct 1999 21:23:07 +0200
Message-ID: <7ttdm8$eoa$3_at_news0.skynet.be>
You need to use capitals in your format string 'YYYYMMDDHH24'). Lower case 'mm' and upper case 'MM' do NOT refer to the same formatting. Refer to your Reference Guid for exact details, please.
-- Dirk Bellemans Modify email address to reply (use .be instead of .belgium) qenr_at_vara.nl wrote in message <3801c7ec.17497662_at_news.omroep.nl>...Received on Mon Oct 11 1999 - 21:23:07 CEST
>Hi all,
>And thanks in advance for any suggestions as how to solve this
>problem.
>
>
>I have a remote database with a couple of date/time columns in
>varchar2 with the following format: 'yyyymmddhh24miss' for example
>(19990901161102)