You're right
Somehow, that’s the reason I started this thread, I’m struggling with how to include functions like “year()” into a SQL statement for SQL server.
Not knowing how to retrieve the year out of the date I went into the null columns etc.
I’ll get rid of the Year column as soon as I find a way to retrieve the year as a single column.
Regards
Oscar Corte
>I'm not sure that's good idea to have separate field for year because you cam always get it from date field.
>
>>
>>I have a date field and an integer field into an SQL table.
>>
>>I need to replace the integer field with the year from the date field. My problem right now is how to build the Update statement in order to accomplish that.
>>
>>So far:
>>
>> “update prueba set table1.year = year(table1.Date) where year is null”
>>
>>does not seem to work. Probably the Update statement is not well constructed, also I ve no idea of how to include functions into SQL statement like the one above.
>>
>< snip >
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only