Function YEAR
Function YEAR
Hi,
I have the lastest verstion of corelab (3.5) and this query dont work:
SELECT YEAR(mydate) as y
FROM entries
MyDate is a datetime field.
Note: DAY, MONTH functions works.
I have the lastest verstion of corelab (3.5) and this query dont work:
SELECT YEAR(mydate) as y
FROM entries
MyDate is a datetime field.
Note: DAY, MONTH functions works.
I've tried the following query with MySQLDirect .NET 3.55
and it does work.
Please make sure you are using the latest version of MySQLDirect .NET.
Code: Select all
select year(hiredate) from emp
Please make sure you are using the latest version of MySQLDirect .NET.
Try to execute Make sure that connection string is the same for both MyDirect .NET and Navicat.
If the problem persists, please specify your hardware platform, operating system, version of MySQL server and send your test project to the address provided in the Readme.html file.
Code: Select all
select year(hiredate) from emp
If the problem persists, please specify your hardware platform, operating system, version of MySQL server and send your test project to the address provided in the Readme.html file.