Select datatype of datetime

[Loi Tan Vo]

Hi,

I have a table containing for ex. a column named MenberDate. The
column has property as datetime. Values look like 13.04.2004
(dd.mm.yyyy) in the table.

Select 'INSERT INTO Menber(Name, MenberDate) VALUES (' Name + ',' ,
cast(menberDate as varchar(12)) + ')' as List from Menber

When I use this sql-statement, the menberDate gives output for ex. Jan
13 2004. It is undesirable.

What I want, is the output of the values look exactly the same
13.04.2004 in the table.

Somebody gives me hints

Thanks in advance

- Loi -

[Hugo Kornelis]

On 2 Apr 2004 00:21:28 -0800, Loi Tan Vo wrote:

Select 'INSERT INTO Menber(Name, MenberDate) VALUES (' Name + ',' ,
cast(menberDate as varchar(12)) + ')' as List from Menber

When I use this sql-statement, the menberDate gives output for ex. Jan
13 2004. It is undesirable.

What I want, is the output of the values look exactly the same
13.04.2004 in the table.

Replace "case(menberDate as varchar(12))" with "convert (varchar(12),
menberDate, 104)".

To get the output I think you want, more changes need done to the
select stmt:

Select 'INSERT INTO Menber(Name, MenberDate) VALUES (''' +
Name + ''', ''' +
convert (varchar(12), menberDate, 104) + ''')' as List
from Menber

Best, Hugo
--

(Remove _NO_ and _SPAM_ to get my e-mail address)