| why date field type change into datetime using odbc connect to oracle XE [message #298137] |
Tue, 05 February 2008 02:14  |
sudiawijaya
Messages: 2
Registered: February 2008
Location: jakarta
|
Junior Member |
|
|
Dear All,
I have a problem,
i connect to oracle xe server throught odbc Oracle XE and i found my date field type has been change into datetime field type. why ? give me a hand !
i using visual foxpro 9 with Sql pass throught tech. with odbc
i have try odbc driver from oracle and windows but those are gave me the same result.
date --> datetime
am i do something wrong ?
|
|
|
|
|
|
| Re: why date field type change into datetime using odbc connect to oracle XE [message #298145 is a reply to message #298141] |
Tue, 05 February 2008 02:36  |
sudiawijaya
Messages: 2
Registered: February 2008
Location: jakarta
|
Junior Member |
|
|
sorry for unknown about that. so oracle date type is odbc datetime type. is that default ? can we change that ?
because i have develop ERP program using Mysql,Postgresql and Sql Server.
and I just known recently that oracle standard edition one is only $149 per named user max 5. so it is make interesting to change my database using oracle .
it is true that oracle brand name is more important then free mysql or postgre. because customer only known that oracle unbreakable.
btw, thanks for explanation may be i should adjust my prog. script became datetime. but it will takes time .
best regards for senior member.
|
|
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
