Anusha Pesala
Last Activity: Apr 8 '13, 01:19 PM
Joined: Apr 8 '13
Location:
-
the type of the column is date type -
when i use the above query still i am getting same errorLeave a comment:
-
Code:SELECT EXTRACT(MONTH FROM mschof) FROM ccdata.rcmast;Leave a comment:
-
I have used Extract function and it is throwing error.
Error: [SQL0171] Argument 1 of function EXTRACT not valid.
SQLState: 42815
ErrorCode: -171Leave a comment:
-
To extract month and year from a column in the table
I have a table which has date as (yyyy-mm-dd)'2000-02-04' ,i want to get only month and year.
i.e the expected result should display 2000,02.
cqan you help me how to get.
No activity results to display
Leave a comment: