Error

I need to adjust the time according to the time zone I am in. Here is my que
ry:
select enddate EDT,
new_time(enddate, 'EDT','PDT')
from project;
Error:
Server: Msg 195, Level 15, State 10, Line 2
'new_time' is not a recognized function name.Is new_time a user-defined function? If so, you need to qualify it with the
owner as in:
dbo.new_time(...)
There's no built-in function called "new_time()". Perhaps GETUTCDATE can be
helpful...
Tibor Karaszi, SQL Server MVP
Archive at:
http://groups.google.com/groups?oi=...ublic.sqlserver
"trgain" <anonymous@.discussions.microsoft.com> wrote in message
news:9B2E3165-7B1E-4F47-98D2-64E33AFB16C7@.microsoft.com...
> I need to adjust the time according to the time zone I am in. Here is my
query:
> select enddate EDT,
> new_time(enddate, 'EDT','PDT')
> from project;
>
> Error:
> Server: Msg 195, Level 15, State 10, Line 2
> 'new_time' is not a recognized function name.
>
>