Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: How to get the DATE part of a DATETIME datatype?

Re: How to get the DATE part of a DATETIME datatype?

From: Anurag Varma <avoracle_at_gmail.com>
Date: 23 Jun 2005 14:57:57 -0700
Message-ID: <1119563877.341758.9980@g47g2000cwa.googlegroups.com>

IIRC: Convert is a sqlserver function used to manipulate dates.

Do not try to apply your knowledge of sql server functions to oracle. Go to tahiti.oracle.com and lookup the oracle documentation. Specifically read the sql reference and lookup the built in function "to_char".

Anurag Received on Thu Jun 23 2005 - 16:57:57 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US