[pgsql-jp: 35908] Re: CURRENT_TIMESTAMP で取得する日時が狂う

2005年 8月 28日 (日) 22:38:24 JST

KCN)$B;0Eg$G$9!#(B

$B$9$_$^$;$s!#?'!9D4$Y$F$$$?$N$G!"%l%9%]%s%9$,CY$/$J$C$F$7$^$$$^$7$?!#(B
$BD4::$N7k2L!"LdBj$rFCDj$9$k$3$H$,$G$-$^$7$?!#(B
	$B"*NkLZ$5$s!">pJs$"$j$,$H$&$4$6$$$^$7$?!#LdBj2r7h$NFMGK8}$K(B
	  $B$J$j$^$7$?!#(B

$B0J2<!"D9J8$K$J$j$^$9$,<:Ni$7$^$9!#(B

---------------------------------------------------------------------
[$B35MW(B]

$BNkLZ$5$s$K65$($F$$$?$@$$$?(BURL$B$,%R%s%H$K$J$j$^$7$?!#(B

	http://www.cygwin.com/ml/cygwin/2004-06/msg01199.html

$B>e5-$N%Z!<%8$G;XE&$7$F$$$k$h$&$K!"(BCygwin$B$G(B49.71$BF|0J>e%W%m%;%9$r(B
$BO"B32TF0$5$;$k$H!"(Bgettimeofday$B4X?t$,JV$9;~9o$,(BWindows$B$N5/F0;~9o$K(B
$BLa$C$F$7$^$&$H$$$&LdBj$,$"$j$^$7$?!#(B

PostgreSQL$B$O(Bgettimeofday$B4X?t$+$i%7%9%F%`;~9o$r<hF@$7$F$$$k$N$G!"(B
$B$3$NLdBj$N1F6A$r<u$1$^$9!#(B

CygWin$B$r:G?7$KF~$lBX$($k$+!"(BPostgreSQL$B$r(B49.71$BF|0JFb$K:F5/F0$9$k(B
$B$3$H$GBP1~$G$-$k$h$&$G$9!#(B

---------------------------------------------------------------------
[$B860x(B]

$B$3$NLdBj$O!"(Bgettimeofday$B4X?t$NCf$GMxMQ$7$F$$$k(BWindows API
(timeGetTime$B4X?t(B)$B$NFC ＠ -$K5/0x$7$F$$$^$9!#(B

timeGetTime$B4X?t$O!"(BWindows$B5/F0;~9o$+$i$N7P2a;~4V$r%_%jIC$N@:EY$G(B
$BJV$7$^$9!#JV$9CM$OId9f$J$7(B32bit$B ＠ 0?t(B(DWORD)$B$G$9!#$7$?$,$C$F!"(B
$B$3$NCM$GI=8=$G$-$kHO0O$OLs(B42$B2/%_%jIC"b(B49.71$BF|$H$J$j$^$9!#(B
49.71$BF|7P2a8e$O!"$3$N%+%&%s%?$O(B0$B$KLa$j$^$9!#(B

$BLdBj$N(Bgettimeofday$B4X?t$N%=!<%9$G$O!"%7%9%F%`;~9o$r7W;;$9$k$N$K!"(B
$B<!$N7W;;<0$rMQ$$$F$$$^$7$?!#(B

	$B%W%m%;%9$N5/F0;~9o(B - ($B8=:_;~9o(B - $B%W%m%;%9$N5/F0;~9o(B)

$B>e5-$N;~9o$O!"$9$Y$F(BtimeGetTime$B4X?t$NJV$9CM$G$9!#%W%m%;%9$N5/F0(B
$B;~9o$O!"Bg0hJQ?t$G5/F0;~$KJ]B8$7$?$b$N$G$9!#(B49.71$BF|8e$K8=:_;~9o$,(B
0$B$KLa$k$H!"%7%9%F%`;~9o$,%W%m%;%9$N5/F0;~9o$KLa$C$F$7$^$$$^$9!#(B


$B8=>]H/@8Ev;~!"(BCygWin$B$N(Bdate$B%3%^%s%I$,JV$98=:_;~9o$O68$C$F$*$i$:!"(B
PostgreSQL$B$@$1$,68$C$F$$$^$7$?!#(B

$B$3$NE@$K>/$7G:$_$^$7$?$,!"<!$N$h$&$J<!Bh$G$7$?!#(B

$B>e5-$N$4$H$/%W%m%;%9$N5/F0;~9o$r7W;;$KF~$l$F$$$k$N$G!"!X%W%m%;%9!Y$,(B
49.71$BF|0J>eO"B3$7$FF0$$$F$$$J$$$+$.$j!"$3$N8=>]$OH/8=$7$^$;$s!#(B

	$B!&(BPostgreSQL$B$N%W%m%;%9$OO"B32TF0$7$F$$$k(B
	$B!&(Bdate$B%3%^%s%I$OKh2s:F<B9T$5$l$k(B

$B$H$$$&0c$$$+$i!":#2s$N$h$&$J8+$(J}$K$J$C$?$H9M$($i$l$^$9!#(B

$B$3$NLdBj$O!"(BCygwin.dll$B$N(B1.5.11-1$B$G3NG'$7$^$7$?!#(B


---------------------------------------------------------------------
[$BBP:v(B]

$B;d$N3NG'$7$?8B$j$G$O!":G6a$N(BCygWin$B$G$O!"K\LdBj$,BP=h$5$l$F$$$k$h$&$K(B
$B8+$($^$9!#(B

$BBP=h8e$N%=!<%9$G$O!"8=:_;~9o$,%W%m%;%95/F0;~9o0JA0$KLa$C$?;v$r(B
$B8!=P$7$?>l9g!"%W%m%;%95/F0;~9o$r<h$jD>$7$F7W;;$9$k$h$&$K$J$C$F(B
$B$$$^$9!#(B

$BK\LdBj$NBP:v$H$7$F$O<!$N$I$A$i$+$,9M$($i$l$^$9!#(B

	$B-!:G?7$N(BCygWin$B$KCV$-49$($k(B
	$B-"(B49.71$BF|0J2<$N<~4|$G(BPostgreSQL$B$N%5!<%S%9$r:F5/F0$9$k(B


$B;dC#$N%7%9%F%`$O!"<B$O4|4V8BDj$N%7%9%F%`$G!";D$jF|?t$b>/$J$$$N$G!"(B
$B-"$G$$$3$&$+$H9M$($F$$$^$9!#(B

$BBP=h$r3NG'$7$?%=!<%9$O!"(BCygwin.dll$B$N(B1.5.14$B$H(B1.5.18($BB?J,:#$N:G?7(B)$B$G$9!#(B


---------------------------------------------------------------------
[$B>/$75$$K$J$k$3$H(B]

$B8=:_$N%m%8%C%/$G ＠ 5$7$/BP=h$5$l$?$h$&$K;W$&$N$G$9$,!"%=!<%9>e$KBP=h(B
$B0JA0$N%3%a%s%H$,!"$J$<$+;D$5$l$?$^$^$K$J$C$F$$$^$9(B(times.cc)$B!#(B

>   // FIXME: Not sure how this will handle the 49.71 day wrap around


$BC1$J$k>C$7K:$l$@$H9M$($i$l$^$9$,!"$b$7$+$9$k$H=$@5<T$K$O$^$@(B
$B5$$K$J$kE@$,$"$k$N$+$b$7$l$^$;$s!#(B

$B8!>Z$7$?$$$H$3$m$J$N$G$9$,!"$J$K$7$m8!>Z$K(B49.71$BF|$+$+$k$N$G$H$F$b!&!&!&!#(B
$B$I$J$?$+J,$+$C$?J}$O$40lJs$$$?$@$1$k$H$&$l$7$$$G$9!#(B


---------------------------------------------------------------------


$B0J>e!"$*<j?t$r$+$1$^$7$?$,!"$"$j$,$H$&$4$6$$$^$7$?!#(B

*               Masaki Mishima                *
*      Fujitsu Kansai Chubu NetTech Inc.      *
*    Tel $B!'(B 81-52-745-2565 (Ext. 7679-8272)   *
*    email$B!'(B mishima.masaki ＠ jp.fujitsu.com    *