Removing time from DATETIME

[system]

HI

Actually i wote one storedprocedure for crystal with DATETIME parameter.
I want only Date from DATETIME

i tried like this

select @abc=convert(varchar,getdate(),101)

But still i am getting the time in User prompt

Is there anyway to remove the time in crystal

---

meher (BOB member since 2008-09-01)

[system]

Hi,
Are you using oracle as the data source or some other data source?

---

Omkar Paranjpe (BOB member since 2006-02-13)

[system]

Hi

How to set it out for oracle database…?

Regards

Siva.M

---

looksmee (BOB member since 2006-02-08)

[system]

Hi,
Yuu can use either to_char or trun function to get only date part.
One caution here, if you have had upt the index on this date column then using the function will disable the index on the database. You will need to put the funcion based index on it then.

---

Omkar Paranjpe (BOB member since 2006-02-13)

[system]

See this blog

---

Jansi (BOB member since 2008-05-12)

[system]

Siva M Wrote :

How to set it out for oracle database…?

To connect with oracle in CR,

select Blank Report > Create New Connection > OracleServer

Give the credentials for Oracle Database.

Thanks

---

Arjun (BOB member since 2008-07-28)

[MarkP]

Both Oracle and SQL Server solutions are covered here:

FAQ: Designer Database Specific

How do I get the current date as an object in my universe? Oracle - define your object as trunc(sysdate) SQL Server - define your object as cast(convert(char(10),getdate(),23) as datetime) This will remove the time section from your getdate() function - just use getdate() if you want current date and time. DB2 - define your object as one of the following CURRENT DATE CURRENT TIME CURRENT TIMESTAMP DATE(CURRENT TIMESTAMP) See this page for more detailed information …