how to convert getdate() to format ddmmyyyy onli??

[headache26]

i tried.. to convert the format to ddmmyyyy format..
by:

declare @ldate datetime
set @ldate = convert(datetime, getdate(),103)
but it appear as result below..

2003-06-13 14:39:43.107


hw can i convert to 13/06/2003 without the time

thanks in advance...

 

[mirtheil]

That looks like an MS SQL Server set of statements. Pervasive.SQL doesn't use datetime. It has separate date and time datatypes as well as a timestamp datatype. As far as your current situation, you might check to see if there are separate Date data types and use those instead of the datetime.

info@mirtheil.com
Custom VB and Btrieve development.
Certified Pervasive Developer
Certified Pervasive Technician

 

[headache26]

i m writing a store procedure..
anyway.. the solution which i found out is--

declare @ldate varchar(20)

set @ldate = convert(char,getdate(),103)

will let @ldate to be in ddmmyyy format w/o the time ..