Discussion Locked

Query returns date in different formats

0 helpful

7 replies

by leightonn Nov 8, 2001 last reply Feb 4, 2002

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

Why does my SQL query return the date in two different formats? After spooling the results to a text file and importing it into Lotus 1-2-3, the date column is in both the date format and character format. Is this a Lotus problem or is it from thequery side?

7 replies

by estebandelatorre Nov 8, 2001

Due to the fact that the text file spooled by the sql server query is A TEXT file, lotus can think of that data (columm) as text or as a date unless you specify what kind of data are you importing.

by shanghai sam Feb 4, 2002

How do I specify the type of data to import? It does not ask me for the data type of the column. I know how to do it in Excel but it does not work still.

by tink Nov 20, 2001

Rather than spooling the results to a text file, run the query through a Query Window. What format is the date in? Are you getting two formats in the result set?