"Ken Winter" <ken@xxxxxxxxxxx> writes: > Yes, that's what I'm trying to do. My problem has been: how to enter the > equivalent of '2006-02-15 10:22:46-05' when the time I want to enter and > convert to EST is a variable value or now(). This still shows a problem in your grasp of what's going on. now() is absolute and should never need to be converted ... regards, tom lane