General discussion

Locked

Query returns date in different formats

By leightonn ·
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?

This conversation is currently closed to new comments.

7 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

Query returns date in different formats

by estebandelatorre In reply to Query returns date in dif ...

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.

Collapse -

Query returns date in different formats

by Shanghai Sam In reply to Query returns date in dif ...

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.

Collapse -

Query returns date in different formats

by TINK In reply to Query returns date in dif ...

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?

Collapse -

Query returns date in different formats

by Shanghai Sam In reply to Query returns date in dif ...

It returns the results in date format. However I want to import the results in Lotus so this still does not solve the problem.

Collapse -

Query returns date in different formats

by nick2001 In reply to Query returns date in dif ...

check your database parameter for date format (like NLS_DATE_FORMAT). Your database format and client format should be different.

Collapse -

Query returns date in different formats

by Shanghai Sam In reply to Query returns date in dif ...

They are different. The server has the format as 'dd-mm-yyyy' the client has 'dd-mon-yyyy'

Collapse -

Query returns date in different formats

by leightonn In reply to Query returns date in dif ...

This question was closed by the author

Back to Desktop Forum
7 total posts (Page 1 of 1)  

Related Forums