Windows 2000 ODBC does't support LEFT, RIGHT (SQL) function?

Thread View: borland.public.cppbuilder.database.ado

1 messages

[T] Back to Threads [V] Tree View [G] Group Articles

1 total messages Started by Nadarajah Nandakumaran Fri, 30 Mar 2001 13:42

#5571

Author: Nadarajah Nandakumaran
Date: Fri, 30 Mar 2001 13:42

14 lines
1184 bytes


I have a database Measurement with a field DateAndTime. I save
"20010330130600" to DateAndTime field.

When I use this:
SELECT LEFT(DateAndTime, 8) AS yyyymmdd, RIGHT(DateAndTime, 6) AS hhnnss
FROM Measurement WHERE .....

I get  following result:  (MEMO)  (MEMO)
Why?. It works with an older Windows 2000 ODBC files.


N. Nandakumaran

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads