Error

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
'new_time' is not a recognized function nameIs 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=djq&as_ugroup=microsoft.public.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.
>
>