How to define column in MS Query ???

[adiyen1]

Hai All,

How to define column in MS Query (ODBC) ???

i have one column like Date of purchase. what i want is to define column based on date of purchase the results showing month of the date of purchase


regards
Adiyen

 

[nbrcrunch]

I should think the MONTH function in query should do it. If not, export your data to Excel and use it's MONTH() function against your date range.

 

[Richard Schollar]

It depends what ODBC driver you are using (ie is it targeting an Access db (in which case MONTH() should work) or an SQL Server one or an Oracle db?

 

[adiyen1]

hai RichardSchollar,

It's an Oracle db


>>>>Hai Mr. nbrcrunch the data is very big i export the data excel. The file size goes more than 6 mb. so that i want to export data in pivot table


Regards,

Adiyen

 

[nbrcrunch]

so we both recommended the MONTH() function in query. did that work for you?

 

[adiyen1]

No it's not working


Regards,

Adiyen

 

[Richard Schollar]

No Month won't work because it's not Access. You need to use an Oracle function which will Cast or convert the values to something else. I am not at all familiar with Oracle syntax so I can't really help other than to suggest you search in Google on Oracle SQL Cast functions and find one that does what you want.

 

[nbrcrunch]

But I thought OP indicating he was using MS Query with an ODBC connection to Oracle. I do the same thing. The Month function in MS Query works for me.

 

[Richard Schollar]

But it won't to an Oracle database (AFAIK anyway) - it depends on the ODBC driver as to what db functions are supported and Oracle doesn't have a Month function (at least I don't think it does).

 

[nbrcrunch]

RETRACTION: OP correct. the function is unavailable. Don't know why I thought it was. Guess I need a another cup of joe.