which function is better YEAR(col) or SUBSTR() (performance)

jajularamesh · New User Joined: 21 Nov 2005 Posts: 8

which function is better YEAR(col) or SUBSTR() performance wise.Actually both are functions so performance will go down.i am using these these functions repeatedly so i wanted to make sure which is better of the two functins.

guptae · Posted: Tue Nov 07, 2006 1:17 pm

Hi Jajularamesh ,

Both the function are for different purpose.
Year() : to find out year of passed given date
Substr():Gives substring of passed string

priyesh.agrawal · Posted: Thu Nov 09, 2006 9:40 am

My cards are on SUBSTR... as we would pass specifically which characters to pick out... Wild guess though...