convert function in the sql

Dev Shed Forums Sponsor:

July 4th, 2005, 02:13 AM

Registered User

Join Date: Jul 2005

Posts: 3

Time spent in forums: 11 m 16 sec
Reputation Power: 0

convert function in the sql

CONVERT(varchar(10),having_date,104) AS having_date

in sql i covert the date field 01.02.2005 00:00:00 to 01.02.2005
how can i do this in oracle

July 6th, 2005, 09:16 AM

......@.........

Join Date: Jun 2004

Posts: 1,308

Time spent in forums: 1 Week 3 Days 5 h 21 sec
Reputation Power: 48

Look up the to_date() function.

July 22nd, 2005, 07:18 PM

Registered User

Join Date: Jul 2005

Posts: 26

Time spent in forums: 6 h 38 m 15 sec
Reputation Power: 0

Quote:

Originally Posted by ayhanozgul

CONVERT(varchar(10),having_date,104) AS having_date

in sql i covert the date field 01.02.2005 00:00:00 to 01.02.2005
how can i do this in oracle

having_date := to_date( '01/02/2005', 'MM/DD/YYYY' );

or

v_date := '01/02/2005';
having_date := to_date( v_date, 'MM/DD/YYYY' );

Viewing: Dev Shed Forums > Databases > Oracle Development > convert function in the sql

Thread Tools	Search this Thread
Email this Page	Search this Thread: Advanced Search
Display Modes	Rate This Thread
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode	Rate This Thread:

Posting Rules
You may not post new threads You may not post replies You may not post attachments You may not edit your posts vB code is On Smilies are On [IMG] code is On HTML code is Off

Forum Jump