Removing time from DATETIME

general discussion
1

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)

2

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

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

3

Hi

How to set it out for oracle database…?

Regards

Siva.M

looksmee :uk: (BOB member since 2006-02-08)

4

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 :us: (BOB member since 2006-02-13)

5

See this blog

Jansi :india: (BOB member since 2008-05-12)

6

Siva M Wrote :

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)

7

Both Oracle and SQL Server solutions are covered here: