Re: RE: datetime fix
| От | Joseph Shraibman |
|---|---|
| Тема | Re: RE: datetime fix |
| Дата | |
| Msg-id | 39F4CD69.5B5724A1@selectacast.net обсуждение исходный текст |
| Ответ на | RE: datetime fix (Ken Kachnowich <khkachn@toad.net>) |
| Список | pgsql-interfaces |
Put query=1 into pg_options to see exactly why query is being executed. Ken Kachnowich wrote: > > Whoops, sorry. I did not know the -04 was the time zone and thought > it was causing my problem. > > My problem still exists, so I may be doing something else wrong. > Has anyone done something like this and does it work? > > - Create a Timestamp with the curret date/time in it > - Insert it into a datetime field in table A > - Insert it into a datetime field in table B > - select the datetime field from table A into a Timestamp variable > - Use this Timestamp variable to select the record from table B > > I get no records found when I do this. > > Ken -- Joseph Shraibman jks@selectacast.net Increase signal to noise ratio. http://www.targabot.com
В списке pgsql-interfaces по дате отправления: