I'm saving the time of which the record gets saved by GETDATE() function. It is taking server time only not location time

I'am recording my timezones.

Its not working as desired.

Actually this is wat am trying to do

CREATE PROCEDURE AAA

AS

BEGIN

CREATE DATABASE DB_USERS;

USE DB_USERS;

CREATE TABLE ADMINUSER (ID INT,UNAME VARCHAR(40),PWD VARCHAR(40));

--IN THE SAME WAY LOT OF TABLES AND PROCEDURES

END

and am getting the...

Hi this is also the same solution but in your cup.

SELECT a.PerFirstJobDate, a.PerFirstName, c.JouDateEnd

FROM UDPersonnel a, UDJob b, UCJobOrgUnit c

WHERE a.PerPK = b.JobPerFK AND b.JobPK = c. JouJobFK...