SEO

Hi when I do the following function it fills 2 dates per day from 1970
to 2050, except that some months (typical 2 months per year) have 4
dates for one day. this is totally freaky.. I wonder if postgresql is
tripping over itself making a double entry every now and again.

for instance I constantly get the following entries

"2006-10-01 00:00:00"
"2006-10-01 23:59:59.999"
"2006-10-01 00:00:00"
"2006-10-01 23:59:59.999"

Any ideas?

Here the function

DECLARE
yearcnt integer;
monthcnt integer;
daycnt integer;

BEGIN

FOR yearcnt IN 1970..2050 LOOP
monthcnt=1;
FOR monthcnt IN 1..12 LOOP
daycnt = 1;
FOR daycnt IN 1..31 LOOP
insert into datepool values
(to_timestamp(yearcnt||'-'||to_char(monthcnt,'FM00')||'-'||to_char(daycnt,'FM09')||'
00:00:00.000','YYYY MM DD HH24:MI:SS.MS'));

insert into datepool values
(to_timestamp(yearcnt||'-'||to_char(monthcnt,'FM00')||'-'||to_char(daycnt,'FM09')||'
23:59:59.999','YYYY MM DD HH24:MI:SS.MS'));


END LOOP;
END LOOP;
END LOOP;

return;

END;

On Mon, Dec 04, 2006 at 06:52:19AM -0800, Ronin wrote:
> Hi when I do the following function it fills 2 dates per day from 1970
> to 2050, except that some months (typical 2 months per year) have 4
> dates for one day. this is totally freaky.. I wonder if postgresql is
> tripping over itself making a double entry every now and again.
>
> for instance I constantly get the following entries

It's either a wierd daylight savings thing, or something to do with the
fact that not all months have 31 days.

Have a nice day,
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.1 (GNU/Linux)

iD8DBQFFdEKDIB7bNG8LQkwRAhe2AJwOEwS2g6QWZa+yTkLIao 9K0Vvr2wCaAvZF
jTBGvA/vKSQDja8svzE1Too=
=sGcG
-----END PGP SIGNATURE-----

> FOR daycnt IN 1..31 LOOP
How about months with less than 31 days ? What do you get for those if
the day is 31 ?

Cheers,
Csaba.



---------------------------(end of broadcast)---------------------------
TIP 6: explain analyze is your friend

Here some add info. It looks like its the 5, 10 and 12 month that
screws up everytime. See 2 years below.

To answer your question, It looks like postgresql does not care if I do
a 31 February, it just does not create that date which is fine by me.

why month 5,10 and 12 screws up is strange. maybe it has something to
do with that 31 days. I dont want to change the sql tho, i mean i dont
want to start coding leap years and all that stuff. I'll just use some
sql to filter the errors out. damn


"1970-01-01 00:00:00"
"1970-01-01 23:59:59.999"
"1970-01-02 00:00:00"
"1970-01-02 23:59:59.999"
"1970-01-03 00:00:00"
"1970-01-03 23:59:59.999"
"1970-01-04 00:00:00"
"1970-01-04 23:59:59.999"
"1970-01-05 00:00:00"
"1970-01-05 23:59:59.999"
"1970-01-06 00:00:00"
"1970-01-06 23:59:59.999"
"1970-01-07 00:00:00"
"1970-01-07 23:59:59.999"
"1970-01-08 00:00:00"
"1970-01-08 23:59:59.999"
"1970-01-09 00:00:00"
"1970-01-09 23:59:59.999"
"1970-01-10 00:00:00"
"1970-01-10 23:59:59.999"
"1970-01-11 00:00:00"
"1970-01-11 23:59:59.999"
"1970-01-12 00:00:00"
"1970-01-12 23:59:59.999"
"1970-01-13 00:00:00"
"1970-01-13 23:59:59.999"
"1970-01-14 00:00:00"
"1970-01-14 23:59:59.999"
"1970-01-15 00:00:00"
"1970-01-15 23:59:59.999"
"1970-01-16 00:00:00"
"1970-01-16 23:59:59.999"
"1970-01-17 00:00:00"
"1970-01-17 23:59:59.999"
"1970-01-18 00:00:00"
"1970-01-18 23:59:59.999"
"1970-01-19 00:00:00"
"1970-01-19 23:59:59.999"
"1970-01-20 00:00:00"
"1970-01-20 23:59:59.999"
"1970-01-21 00:00:00"
"1970-01-21 23:59:59.999"
"1970-01-22 00:00:00"
"1970-01-22 23:59:59.999"
"1970-01-23 00:00:00"
"1970-01-23 23:59:59.999"
"1970-01-24 00:00:00"
"1970-01-24 23:59:59.999"
"1970-01-25 00:00:00"
"1970-01-25 23:59:59.999"
"1970-01-26 00:00:00"
"1970-01-26 23:59:59.999"
"1970-01-27 00:00:00"
"1970-01-27 23:59:59.999"
"1970-01-28 00:00:00"
"1970-01-28 23:59:59.999"
"1970-01-29 00:00:00"
"1970-01-29 23:59:59.999"
"1970-01-30 00:00:00"
"1970-01-30 23:59:59.999"
"1970-01-31 00:00:00"
"1970-01-31 23:59:59.999"
"1970-02-01 00:00:00"
"1970-02-01 23:59:59.999"
"1970-02-02 00:00:00"
"1970-02-02 23:59:59.999"
"1970-02-03 00:00:00"
"1970-02-03 23:59:59.999"
"1970-02-04 00:00:00"
"1970-02-04 23:59:59.999"
"1970-02-05 00:00:00"
"1970-02-05 23:59:59.999"
"1970-02-06 00:00:00"
"1970-02-06 23:59:59.999"
"1970-02-07 00:00:00"
"1970-02-07 23:59:59.999"
"1970-02-08 00:00:00"
"1970-02-08 23:59:59.999"
"1970-02-09 00:00:00"
"1970-02-09 23:59:59.999"
"1970-02-10 00:00:00"
"1970-02-10 23:59:59.999"
"1970-02-11 00:00:00"
"1970-02-11 23:59:59.999"
"1970-02-12 00:00:00"
"1970-02-12 23:59:59.999"
"1970-02-13 00:00:00"
"1970-02-13 23:59:59.999"
"1970-02-14 00:00:00"
"1970-02-14 23:59:59.999"
"1970-02-15 00:00:00"
"1970-02-15 23:59:59.999"
"1970-02-16 00:00:00"
"1970-02-16 23:59:59.999"
"1970-02-17 00:00:00"
"1970-02-17 23:59:59.999"
"1970-02-18 00:00:00"
"1970-02-18 23:59:59.999"
"1970-02-19 00:00:00"
"1970-02-19 23:59:59.999"
"1970-02-20 00:00:00"
"1970-02-20 23:59:59.999"
"1970-02-21 00:00:00"
"1970-02-21 23:59:59.999"
"1970-02-22 00:00:00"
"1970-02-22 23:59:59.999"
"1970-02-23 00:00:00"
"1970-02-23 23:59:59.999"
"1970-02-24 00:00:00"
"1970-02-24 23:59:59.999"
"1970-02-25 00:00:00"
"1970-02-25 23:59:59.999"
"1970-02-26 00:00:00"
"1970-02-26 23:59:59.999"
"1970-02-27 00:00:00"
"1970-02-27 23:59:59.999"
"1970-02-28 00:00:00"
"1970-02-28 23:59:59.999"
"1970-03-01 00:00:00"
"1970-03-01 23:59:59.999"
"1970-03-02 00:00:00"
"1970-03-02 23:59:59.999"
"1970-03-03 00:00:00"
"1970-03-03 23:59:59.999"
"1970-03-01 00:00:00"
"1970-03-01 23:59:59.999"
"1970-03-02 00:00:00"
"1970-03-02 23:59:59.999"
"1970-03-03 00:00:00"
"1970-03-03 23:59:59.999"
"1970-03-04 00:00:00"
"1970-03-04 23:59:59.999"
"1970-03-05 00:00:00"
"1970-03-05 23:59:59.999"
"1970-03-06 00:00:00"
"1970-03-06 23:59:59.999"
"1970-03-07 00:00:00"
"1970-03-07 23:59:59.999"
"1970-03-08 00:00:00"
"1970-03-08 23:59:59.999"
"1970-03-09 00:00:00"
"1970-03-09 23:59:59.999"
"1970-03-10 00:00:00"
"1970-03-10 23:59:59.999"
"1970-03-11 00:00:00"
"1970-03-11 23:59:59.999"
"1970-03-12 00:00:00"
"1970-03-12 23:59:59.999"
"1970-03-13 00:00:00"
"1970-03-13 23:59:59.999"
"1970-03-14 00:00:00"
"1970-03-14 23:59:59.999"
"1970-03-15 00:00:00"
"1970-03-15 23:59:59.999"
"1970-03-16 00:00:00"
"1970-03-16 23:59:59.999"
"1970-03-17 00:00:00"
"1970-03-17 23:59:59.999"
"1970-03-18 00:00:00"
"1970-03-18 23:59:59.999"
"1970-03-19 00:00:00"
"1970-03-19 23:59:59.999"
"1970-03-20 00:00:00"
"1970-03-20 23:59:59.999"
"1970-03-21 00:00:00"
"1970-03-21 23:59:59.999"
"1970-03-22 00:00:00"
"1970-03-22 23:59:59.999"
"1970-03-23 00:00:00"
"1970-03-23 23:59:59.999"
"1970-03-24 00:00:00"
"1970-03-24 23:59:59.999"
"1970-03-25 00:00:00"
"1970-03-25 23:59:59.999"
"1970-03-26 00:00:00"
"1970-03-26 23:59:59.999"
"1970-03-27 00:00:00"
"1970-03-27 23:59:59.999"
"1970-03-28 00:00:00"
"1970-03-28 23:59:59.999"
"1970-03-29 00:00:00"
"1970-03-29 23:59:59.999"
"1970-03-30 00:00:00"
"1970-03-30 23:59:59.999"
"1970-03-31 00:00:00"
"1970-03-31 23:59:59.999"
"1970-04-01 00:00:00"
"1970-04-01 23:59:59.999"
"1970-04-02 00:00:00"
"1970-04-02 23:59:59.999"
"1970-04-03 00:00:00"
"1970-04-03 23:59:59.999"
"1970-04-04 00:00:00"
"1970-04-04 23:59:59.999"
"1970-04-05 00:00:00"
"1970-04-05 23:59:59.999"
"1970-04-06 00:00:00"
"1970-04-06 23:59:59.999"
"1970-04-07 00:00:00"
"1970-04-07 23:59:59.999"
"1970-04-08 00:00:00"
"1970-04-08 23:59:59.999"
"1970-04-09 00:00:00"
"1970-04-09 23:59:59.999"
"1970-04-10 00:00:00"
"1970-04-10 23:59:59.999"
"1970-04-11 00:00:00"
"1970-04-11 23:59:59.999"
"1970-04-12 00:00:00"
"1970-04-12 23:59:59.999"
"1970-04-13 00:00:00"
"1970-04-13 23:59:59.999"
"1970-04-14 00:00:00"
"1970-04-14 23:59:59.999"
"1970-04-15 00:00:00"
"1970-04-15 23:59:59.999"
"1970-04-16 00:00:00"
"1970-04-16 23:59:59.999"
"1970-04-17 00:00:00"
"1970-04-17 23:59:59.999"
"1970-04-18 00:00:00"
"1970-04-18 23:59:59.999"
"1970-04-19 00:00:00"
"1970-04-19 23:59:59.999"
"1970-04-20 00:00:00"
"1970-04-20 23:59:59.999"
"1970-04-21 00:00:00"
"1970-04-21 23:59:59.999"
"1970-04-22 00:00:00"
"1970-04-22 23:59:59.999"
"1970-04-23 00:00:00"
"1970-04-23 23:59:59.999"
"1970-04-24 00:00:00"
"1970-04-24 23:59:59.999"
"1970-04-25 00:00:00"
"1970-04-25 23:59:59.999"
"1970-04-26 00:00:00"
"1970-04-26 23:59:59.999"
"1970-04-27 00:00:00"
"1970-04-27 23:59:59.999"
"1970-04-28 00:00:00"
"1970-04-28 23:59:59.999"
"1970-04-29 00:00:00"
"1970-04-29 23:59:59.999"
"1970-04-30 00:00:00"
"1970-04-30 23:59:59.999"
"1970-05-01 00:00:00"
"1970-05-01 23:59:59.999"
"1970-05-01 00:00:00"
"1970-05-01 23:59:59.999"
"1970-05-02 00:00:00"
"1970-05-02 23:59:59.999"
"1970-05-03 00:00:00"
"1970-05-03 23:59:59.999"
"1970-05-04 00:00:00"
"1970-05-04 23:59:59.999"
"1970-05-05 00:00:00"
"1970-05-05 23:59:59.999"
"1970-05-06 00:00:00"
"1970-05-06 23:59:59.999"
"1970-05-07 00:00:00"
"1970-05-07 23:59:59.999"
"1970-05-08 00:00:00"
"1970-05-08 23:59:59.999"
"1970-05-09 00:00:00"
"1970-05-09 23:59:59.999"
"1970-05-10 00:00:00"
"1970-05-10 23:59:59.999"
"1970-05-11 00:00:00"
"1970-05-11 23:59:59.999"
"1970-05-12 00:00:00"
"1970-05-12 23:59:59.999"
"1970-05-13 00:00:00"
"1970-05-13 23:59:59.999"
"1970-05-14 00:00:00"
"1970-05-14 23:59:59.999"
"1970-05-15 00:00:00"
"1970-05-15 23:59:59.999"
"1970-05-16 00:00:00"
"1970-05-16 23:59:59.999"
"1970-05-17 00:00:00"
"1970-05-17 23:59:59.999"
"1970-05-18 00:00:00"
"1970-05-18 23:59:59.999"
"1970-05-19 00:00:00"
"1970-05-19 23:59:59.999"
"1970-05-20 00:00:00"
"1970-05-20 23:59:59.999"
"1970-05-21 00:00:00"
"1970-05-21 23:59:59.999"
"1970-05-22 00:00:00"
"1970-05-22 23:59:59.999"
"1970-05-23 00:00:00"
"1970-05-23 23:59:59.999"
"1970-05-24 00:00:00"
"1970-05-24 23:59:59.999"
"1970-05-25 00:00:00"
"1970-05-25 23:59:59.999"
"1970-05-26 00:00:00"
"1970-05-26 23:59:59.999"
"1970-05-27 00:00:00"
"1970-05-27 23:59:59.999"
"1970-05-28 00:00:00"
"1970-05-28 23:59:59.999"
"1970-05-29 00:00:00"
"1970-05-29 23:59:59.999"
"1970-05-30 00:00:00"
"1970-05-30 23:59:59.999"
"1970-05-31 00:00:00"
"1970-05-31 23:59:59.999"
"1970-06-01 00:00:00"
"1970-06-01 23:59:59.999"
"1970-06-02 00:00:00"
"1970-06-02 23:59:59.999"
"1970-06-03 00:00:00"
"1970-06-03 23:59:59.999"
"1970-06-04 00:00:00"
"1970-06-04 23:59:59.999"
"1970-06-05 00:00:00"
"1970-06-05 23:59:59.999"
"1970-06-06 00:00:00"
"1970-06-06 23:59:59.999"
"1970-06-07 00:00:00"
"1970-06-07 23:59:59.999"
"1970-06-08 00:00:00"
"1970-06-08 23:59:59.999"
"1970-06-09 00:00:00"
"1970-06-09 23:59:59.999"
"1970-06-10 00:00:00"
"1970-06-10 23:59:59.999"
"1970-06-11 00:00:00"
"1970-06-11 23:59:59.999"
"1970-06-12 00:00:00"
"1970-06-12 23:59:59.999"
"1970-06-13 00:00:00"
"1970-06-13 23:59:59.999"
"1970-06-14 00:00:00"
"1970-06-14 23:59:59.999"
"1970-06-15 00:00:00"
"1970-06-15 23:59:59.999"
"1970-06-16 00:00:00"
"1970-06-16 23:59:59.999"
"1970-06-17 00:00:00"
"1970-06-17 23:59:59.999"
"1970-06-18 00:00:00"
"1970-06-18 23:59:59.999"
"1970-06-19 00:00:00"
"1970-06-19 23:59:59.999"
"1970-06-20 00:00:00"
"1970-06-20 23:59:59.999"
"1970-06-21 00:00:00"
"1970-06-21 23:59:59.999"
"1970-06-22 00:00:00"
"1970-06-22 23:59:59.999"
"1970-06-23 00:00:00"
"1970-06-23 23:59:59.999"
"1970-06-24 00:00:00"
"1970-06-24 23:59:59.999"
"1970-06-25 00:00:00"
"1970-06-25 23:59:59.999"
"1970-06-26 00:00:00"
"1970-06-26 23:59:59.999"
"1970-06-27 00:00:00"
"1970-06-27 23:59:59.999"
"1970-06-28 00:00:00"
"1970-06-28 23:59:59.999"
"1970-06-29 00:00:00"
"1970-06-29 23:59:59.999"
"1970-06-30 00:00:00"
"1970-06-30 23:59:59.999"
"1970-07-01 00:00:00"
"1970-07-01 23:59:59.999"
"1970-07-01 00:00:00"
"1970-07-01 23:59:59.999"
"1970-07-02 00:00:00"
"1970-07-02 23:59:59.999"
"1970-07-03 00:00:00"
"1970-07-03 23:59:59.999"
"1970-07-04 00:00:00"
"1970-07-04 23:59:59.999"
"1970-07-05 00:00:00"
"1970-07-05 23:59:59.999"
"1970-07-06 00:00:00"
"1970-07-06 23:59:59.999"
"1970-07-07 00:00:00"
"1970-07-07 23:59:59.999"
"1970-07-08 00:00:00"
"1970-07-08 23:59:59.999"
"1970-07-09 00:00:00"
"1970-07-09 23:59:59.999"
"1970-07-10 00:00:00"
"1970-07-10 23:59:59.999"
"1970-07-11 00:00:00"
"1970-07-11 23:59:59.999"
"1970-07-12 00:00:00"
"1970-07-12 23:59:59.999"
"1970-07-13 00:00:00"
"1970-07-13 23:59:59.999"
"1970-07-14 00:00:00"
"1970-07-14 23:59:59.999"
"1970-07-15 00:00:00"
"1970-07-15 23:59:59.999"
"1970-07-16 00:00:00"
"1970-07-16 23:59:59.999"
"1970-07-17 00:00:00"
"1970-07-17 23:59:59.999"
"1970-07-18 00:00:00"
"1970-07-18 23:59:59.999"
"1970-07-19 00:00:00"
"1970-07-19 23:59:59.999"
"1970-07-20 00:00:00"
"1970-07-20 23:59:59.999"
"1970-07-21 00:00:00"
"1970-07-21 23:59:59.999"
"1970-07-22 00:00:00"
"1970-07-22 23:59:59.999"
"1970-07-23 00:00:00"
"1970-07-23 23:59:59.999"
"1970-07-24 00:00:00"
"1970-07-24 23:59:59.999"
"1970-07-25 00:00:00"
"1970-07-25 23:59:59.999"
"1970-07-26 00:00:00"
"1970-07-26 23:59:59.999"
"1970-07-27 00:00:00"
"1970-07-27 23:59:59.999"
"1970-07-28 00:00:00"
"1970-07-28 23:59:59.999"
"1970-07-29 00:00:00"
"1970-07-29 23:59:59.999"
"1970-07-30 00:00:00"
"1970-07-30 23:59:59.999"
"1970-07-31 00:00:00"
"1970-07-31 23:59:59.999"
"1970-08-01 00:00:00"
"1970-08-01 23:59:59.999"
"1970-08-02 00:00:00"
"1970-08-02 23:59:59.999"
"1970-08-03 00:00:00"
"1970-08-03 23:59:59.999"
"1970-08-04 00:00:00"
"1970-08-04 23:59:59.999"
"1970-08-05 00:00:00"
"1970-08-05 23:59:59.999"
"1970-08-06 00:00:00"
"1970-08-06 23:59:59.999"
"1970-08-07 00:00:00"
"1970-08-07 23:59:59.999"
"1970-08-08 00:00:00"
"1970-08-08 23:59:59.999"
"1970-08-09 00:00:00"
"1970-08-09 23:59:59.999"
"1970-08-10 00:00:00"
"1970-08-10 23:59:59.999"
"1970-08-11 00:00:00"
"1970-08-11 23:59:59.999"
"1970-08-12 00:00:00"
"1970-08-12 23:59:59.999"
"1970-08-13 00:00:00"
"1970-08-13 23:59:59.999"
"1970-08-14 00:00:00"
"1970-08-14 23:59:59.999"
"1970-08-15 00:00:00"
"1970-08-15 23:59:59.999"
"1970-08-16 00:00:00"
"1970-08-16 23:59:59.999"
"1970-08-17 00:00:00"
"1970-08-17 23:59:59.999"
"1970-08-18 00:00:00"
"1970-08-18 23:59:59.999"
"1970-08-19 00:00:00"
"1970-08-19 23:59:59.999"
"1970-08-20 00:00:00"
"1970-08-20 23:59:59.999"
"1970-08-21 00:00:00"
"1970-08-21 23:59:59.999"
"1970-08-22 00:00:00"
"1970-08-22 23:59:59.999"
"1970-08-23 00:00:00"
"1970-08-23 23:59:59.999"
"1970-08-24 00:00:00"
"1970-08-24 23:59:59.999"
"1970-08-25 00:00:00"
"1970-08-25 23:59:59.999"
"1970-08-26 00:00:00"
"1970-08-26 23:59:59.999"
"1970-08-27 00:00:00"
"1970-08-27 23:59:59.999"
"1970-08-28 00:00:00"
"1970-08-28 23:59:59.999"
"1970-08-29 00:00:00"
"1970-08-29 23:59:59.999"
"1970-08-30 00:00:00"
"1970-08-30 23:59:59.999"
"1970-08-31 00:00:00"
"1970-08-31 23:59:59.999"
"1970-09-01 00:00:00"
"1970-09-01 23:59:59.999"
"1970-09-02 00:00:00"
"1970-09-02 23:59:59.999"
"1970-09-03 00:00:00"
"1970-09-03 23:59:59.999"
"1970-09-04 00:00:00"
"1970-09-04 23:59:59.999"
"1970-09-05 00:00:00"
"1970-09-05 23:59:59.999"
"1970-09-06 00:00:00"
"1970-09-06 23:59:59.999"
"1970-09-07 00:00:00"
"1970-09-07 23:59:59.999"
"1970-09-08 00:00:00"
"1970-09-08 23:59:59.999"
"1970-09-09 00:00:00"
"1970-09-09 23:59:59.999"
"1970-09-10 00:00:00"
"1970-09-10 23:59:59.999"
"1970-09-11 00:00:00"
"1970-09-11 23:59:59.999"
"1970-09-12 00:00:00"
"1970-09-12 23:59:59.999"
"1970-09-13 00:00:00"
"1970-09-13 23:59:59.999"
"1970-09-14 00:00:00"
"1970-09-14 23:59:59.999"
"1970-09-15 00:00:00"
"1970-09-15 23:59:59.999"
"1970-09-16 00:00:00"
"1970-09-16 23:59:59.999"
"1970-09-17 00:00:00"
"1970-09-17 23:59:59.999"
"1970-09-18 00:00:00"
"1970-09-18 23:59:59.999"
"1970-09-19 00:00:00"
"1970-09-19 23:59:59.999"
"1970-09-20 00:00:00"
"1970-09-20 23:59:59.999"
"1970-09-21 00:00:00"
"1970-09-21 23:59:59.999"
"1970-09-22 00:00:00"
"1970-09-22 23:59:59.999"
"1970-09-23 00:00:00"
"1970-09-23 23:59:59.999"
"1970-09-24 00:00:00"
"1970-09-24 23:59:59.999"
"1970-09-25 00:00:00"
"1970-09-25 23:59:59.999"
"1970-09-26 00:00:00"
"1970-09-26 23:59:59.999"
"1970-09-27 00:00:00"
"1970-09-27 23:59:59.999"
"1970-09-28 00:00:00"
"1970-09-28 23:59:59.999"
"1970-09-29 00:00:00"
"1970-09-29 23:59:59.999"
"1970-09-30 00:00:00"
"1970-09-30 23:59:59.999"
"1970-10-01 00:00:00"
"1970-10-01 23:59:59.999"
"1970-10-01 00:00:00"
"1970-10-01 23:59:59.999"
"1970-10-02 00:00:00"
"1970-10-02 23:59:59.999"
"1970-10-03 00:00:00"
"1970-10-03 23:59:59.999"
"1970-10-04 00:00:00"
"1970-10-04 23:59:59.999"
"1970-10-05 00:00:00"
"1970-10-05 23:59:59.999"
"1970-10-06 00:00:00"
"1970-10-06 23:59:59.999"
"1970-10-07 00:00:00"
"1970-10-07 23:59:59.999"
"1970-10-08 00:00:00"
"1970-10-08 23:59:59.999"
"1970-10-09 00:00:00"
"1970-10-09 23:59:59.999"
"1970-10-10 00:00:00"
"1970-10-10 23:59:59.999"
"1970-10-11 00:00:00"
"1970-10-11 23:59:59.999"
"1970-10-12 00:00:00"
"1970-10-12 23:59:59.999"
"1970-10-13 00:00:00"
"1970-10-13 23:59:59.999"
"1970-10-14 00:00:00"
"1970-10-14 23:59:59.999"
"1970-10-15 00:00:00"
"1970-10-15 23:59:59.999"
"1970-10-16 00:00:00"
"1970-10-16 23:59:59.999"
"1970-10-17 00:00:00"
"1970-10-17 23:59:59.999"
"1970-10-18 00:00:00"
"1970-10-18 23:59:59.999"
"1970-10-19 00:00:00"
"1970-10-19 23:59:59.999"
"1970-10-20 00:00:00"
"1970-10-20 23:59:59.999"
"1970-10-21 00:00:00"
"1970-10-21 23:59:59.999"
"1970-10-22 00:00:00"
"1970-10-22 23:59:59.999"
"1970-10-23 00:00:00"
"1970-10-23 23:59:59.999"
"1970-10-24 00:00:00"
"1970-10-24 23:59:59.999"
"1970-10-25 00:00:00"
"1970-10-25 23:59:59.999"
"1970-10-26 00:00:00"
"1970-10-26 23:59:59.999"
"1970-10-27 00:00:00"
"1970-10-27 23:59:59.999"
"1970-10-28 00:00:00"
"1970-10-28 23:59:59.999"
"1970-10-29 00:00:00"
"1970-10-29 23:59:59.999"
"1970-10-30 00:00:00"
"1970-10-30 23:59:59.999"
"1970-10-31 00:00:00"
"1970-10-31 23:59:59.999"
"1970-11-01 00:00:00"
"1970-11-01 23:59:59.999"
"1970-11-02 00:00:00"
"1970-11-02 23:59:59.999"
"1970-11-03 00:00:00"
"1970-11-03 23:59:59.999"
"1970-11-04 00:00:00"
"1970-11-04 23:59:59.999"
"1970-11-05 00:00:00"
"1970-11-05 23:59:59.999"
"1970-11-06 00:00:00"
"1970-11-06 23:59:59.999"
"1970-11-07 00:00:00"
"1970-11-07 23:59:59.999"
"1970-11-08 00:00:00"
"1970-11-08 23:59:59.999"
"1970-11-09 00:00:00"
"1970-11-09 23:59:59.999"
"1970-11-10 00:00:00"
"1970-11-10 23:59:59.999"
"1970-11-11 00:00:00"
"1970-11-11 23:59:59.999"
"1970-11-12 00:00:00"
"1970-11-12 23:59:59.999"
"1970-11-13 00:00:00"
"1970-11-13 23:59:59.999"
"1970-11-14 00:00:00"
"1970-11-14 23:59:59.999"
"1970-11-15 00:00:00"
"1970-11-15 23:59:59.999"
"1970-11-16 00:00:00"
"1970-11-16 23:59:59.999"
"1970-11-17 00:00:00"
"1970-11-17 23:59:59.999"
"1970-11-18 00:00:00"
"1970-11-18 23:59:59.999"
"1970-11-19 00:00:00"
"1970-11-19 23:59:59.999"
"1970-11-20 00:00:00"
"1970-11-20 23:59:59.999"
"1970-11-21 00:00:00"
"1970-11-21 23:59:59.999"
"1970-11-22 00:00:00"
"1970-11-22 23:59:59.999"
"1970-11-23 00:00:00"
"1970-11-23 23:59:59.999"
"1970-11-24 00:00:00"
"1970-11-24 23:59:59.999"
"1970-11-25 00:00:00"
"1970-11-25 23:59:59.999"
"1970-11-26 00:00:00"
"1970-11-26 23:59:59.999"
"1970-11-27 00:00:00"
"1970-11-27 23:59:59.999"
"1970-11-28 00:00:00"
"1970-11-28 23:59:59.999"
"1970-11-29 00:00:00"
"1970-11-29 23:59:59.999"
"1970-11-30 00:00:00"
"1970-11-30 23:59:59.999"
"1970-12-01 00:00:00"
"1970-12-01 23:59:59.999"
"1970-12-01 00:00:00"
"1970-12-01 23:59:59.999"
"1970-12-02 00:00:00"
"1970-12-02 23:59:59.999"
"1970-12-03 00:00:00"
"1970-12-03 23:59:59.999"
"1970-12-04 00:00:00"
"1970-12-04 23:59:59.999"
"1970-12-05 00:00:00"
"1970-12-05 23:59:59.999"
"1970-12-06 00:00:00"
"1970-12-06 23:59:59.999"
"1970-12-07 00:00:00"
"1970-12-07 23:59:59.999"
"1970-12-08 00:00:00"
"1970-12-08 23:59:59.999"
"1970-12-09 00:00:00"
"1970-12-09 23:59:59.999"
"1970-12-10 00:00:00"
"1970-12-10 23:59:59.999"
"1970-12-11 00:00:00"
"1970-12-11 23:59:59.999"
"1970-12-12 00:00:00"
"1970-12-12 23:59:59.999"
"1970-12-13 00:00:00"
"1970-12-13 23:59:59.999"
"1970-12-14 00:00:00"
"1970-12-14 23:59:59.999"
"1970-12-15 00:00:00"
"1970-12-15 23:59:59.999"
"1970-12-16 00:00:00"
"1970-12-16 23:59:59.999"
"1970-12-17 00:00:00"
"1970-12-17 23:59:59.999"
"1970-12-18 00:00:00"
"1970-12-18 23:59:59.999"
"1970-12-19 00:00:00"
"1970-12-19 23:59:59.999"
"1970-12-20 00:00:00"
"1970-12-20 23:59:59.999"
"1970-12-21 00:00:00"
"1970-12-21 23:59:59.999"
"1970-12-22 00:00:00"
"1970-12-22 23:59:59.999"
"1970-12-23 00:00:00"
"1970-12-23 23:59:59.999"
"1970-12-24 00:00:00"
"1970-12-24 23:59:59.999"
"1970-12-25 00:00:00"
"1970-12-25 23:59:59.999"
"1970-12-26 00:00:00"
"1970-12-26 23:59:59.999"
"1970-12-27 00:00:00"
"1970-12-27 23:59:59.999"
"1970-12-28 00:00:00"
"1970-12-28 23:59:59.999"
"1970-12-29 00:00:00"
"1970-12-29 23:59:59.999"
"1970-12-30 00:00:00"
"1970-12-30 23:59:59.999"
"1970-12-31 00:00:00"
"1970-12-31 23:59:59.999"
"1971-01-01 00:00:00"
"1971-01-01 23:59:59.999"
"1971-01-02 00:00:00"
"1971-01-02 23:59:59.999"
"1971-01-03 00:00:00"
"1971-01-03 23:59:59.999"
"1971-01-04 00:00:00"
"1971-01-04 23:59:59.999"
"1971-01-05 00:00:00"
"1971-01-05 23:59:59.999"
"1971-01-06 00:00:00"
"1971-01-06 23:59:59.999"
"1971-01-07 00:00:00"
"1971-01-07 23:59:59.999"
"1971-01-08 00:00:00"
"1971-01-08 23:59:59.999"
"1971-01-09 00:00:00"
"1971-01-09 23:59:59.999"
"1971-01-10 00:00:00"
"1971-01-10 23:59:59.999"
"1971-01-11 00:00:00"
"1971-01-11 23:59:59.999"
"1971-01-12 00:00:00"
"1971-01-12 23:59:59.999"
"1971-01-13 00:00:00"
"1971-01-13 23:59:59.999"
"1971-01-14 00:00:00"
"1971-01-14 23:59:59.999"
"1971-01-15 00:00:00"
"1971-01-15 23:59:59.999"
"1971-01-16 00:00:00"
"1971-01-16 23:59:59.999"
"1971-01-17 00:00:00"
"1971-01-17 23:59:59.999"
"1971-01-18 00:00:00"
"1971-01-18 23:59:59.999"
"1971-01-19 00:00:00"
"1971-01-19 23:59:59.999"
"1971-01-20 00:00:00"
"1971-01-20 23:59:59.999"
"1971-01-21 00:00:00"
"1971-01-21 23:59:59.999"
"1971-01-22 00:00:00"
"1971-01-22 23:59:59.999"
"1971-01-23 00:00:00"
"1971-01-23 23:59:59.999"
"1971-01-24 00:00:00"
"1971-01-24 23:59:59.999"
"1971-01-25 00:00:00"
"1971-01-25 23:59:59.999"
"1971-01-26 00:00:00"
"1971-01-26 23:59:59.999"
"1971-01-27 00:00:00"
"1971-01-27 23:59:59.999"
"1971-01-28 00:00:00"
"1971-01-28 23:59:59.999"
"1971-01-29 00:00:00"
"1971-01-29 23:59:59.999"
"1971-01-30 00:00:00"
"1971-01-30 23:59:59.999"
"1971-01-31 00:00:00"
"1971-01-31 23:59:59.999"
"1971-02-01 00:00:00"
"1971-02-01 23:59:59.999"
"1971-02-02 00:00:00"
"1971-02-02 23:59:59.999"
"1971-02-03 00:00:00"
"1971-02-03 23:59:59.999"
"1971-02-04 00:00:00"
"1971-02-04 23:59:59.999"
"1971-02-05 00:00:00"
"1971-02-05 23:59:59.999"
"1971-02-06 00:00:00"
"1971-02-06 23:59:59.999"
"1971-02-07 00:00:00"
"1971-02-07 23:59:59.999"
"1971-02-08 00:00:00"
"1971-02-08 23:59:59.999"
"1971-02-09 00:00:00"
"1971-02-09 23:59:59.999"
"1971-02-10 00:00:00"
"1971-02-10 23:59:59.999"
"1971-02-11 00:00:00"
"1971-02-11 23:59:59.999"
"1971-02-12 00:00:00"
"1971-02-12 23:59:59.999"
"1971-02-13 00:00:00"
"1971-02-13 23:59:59.999"
"1971-02-14 00:00:00"
"1971-02-14 23:59:59.999"
"1971-02-15 00:00:00"
"1971-02-15 23:59:59.999"
"1971-02-16 00:00:00"
"1971-02-16 23:59:59.999"
"1971-02-17 00:00:00"
"1971-02-17 23:59:59.999"
"1971-02-18 00:00:00"
"1971-02-18 23:59:59.999"
"1971-02-19 00:00:00"
"1971-02-19 23:59:59.999"
"1971-02-20 00:00:00"
"1971-02-20 23:59:59.999"
"1971-02-21 00:00:00"
"1971-02-21 23:59:59.999"
"1971-02-22 00:00:00"
"1971-02-22 23:59:59.999"
"1971-02-23 00:00:00"
"1971-02-23 23:59:59.999"
"1971-02-24 00:00:00"
"1971-02-24 23:59:59.999"
"1971-02-25 00:00:00"
"1971-02-25 23:59:59.999"
"1971-02-26 00:00:00"
"1971-02-26 23:59:59.999"
"1971-02-27 00:00:00"
"1971-02-27 23:59:59.999"
"1971-02-28 00:00:00"
"1971-02-28 23:59:59.999"
"1971-03-01 00:00:00"
"1971-03-01 23:59:59.999"
"1971-03-02 00:00:00"
"1971-03-02 23:59:59.999"
"1971-03-03 00:00:00"
"1971-03-03 23:59:59.999"
"1971-03-01 00:00:00"
"1971-03-01 23:59:59.999"
"1971-03-02 00:00:00"
"1971-03-02 23:59:59.999"
"1971-03-03 00:00:00"
"1971-03-03 23:59:59.999"
"1971-03-04 00:00:00"
"1971-03-04 23:59:59.999"
"1971-03-05 00:00:00"
"1971-03-05 23:59:59.999"
"1971-03-06 00:00:00"
"1971-03-06 23:59:59.999"
"1971-03-07 00:00:00"
"1971-03-07 23:59:59.999"
"1971-03-08 00:00:00"
"1971-03-08 23:59:59.999"
"1971-03-09 00:00:00"
"1971-03-09 23:59:59.999"
"1971-03-10 00:00:00"
"1971-03-10 23:59:59.999"
"1971-03-11 00:00:00"
"1971-03-11 23:59:59.999"
"1971-03-12 00:00:00"
"1971-03-12 23:59:59.999"
"1971-03-13 00:00:00"
"1971-03-13 23:59:59.999"
"1971-03-14 00:00:00"
"1971-03-14 23:59:59.999"
"1971-03-15 00:00:00"
"1971-03-15 23:59:59.999"
"1971-03-16 00:00:00"
"1971-03-16 23:59:59.999"
"1971-03-17 00:00:00"
"1971-03-17 23:59:59.999"
"1971-03-18 00:00:00"
"1971-03-18 23:59:59.999"
"1971-03-19 00:00:00"
"1971-03-19 23:59:59.999"
"1971-03-20 00:00:00"
"1971-03-20 23:59:59.999"
"1971-03-21 00:00:00"
"1971-03-21 23:59:59.999"
"1971-03-22 00:00:00"
"1971-03-22 23:59:59.999"
"1971-03-23 00:00:00"
"1971-03-23 23:59:59.999"
"1971-03-24 00:00:00"
"1971-03-24 23:59:59.999"
"1971-03-25 00:00:00"
"1971-03-25 23:59:59.999"
"1971-03-26 00:00:00"
"1971-03-26 23:59:59.999"
"1971-03-27 00:00:00"
"1971-03-27 23:59:59.999"
"1971-03-28 00:00:00"
"1971-03-28 23:59:59.999"
"1971-03-29 00:00:00"
"1971-03-29 23:59:59.999"
"1971-03-30 00:00:00"
"1971-03-30 23:59:59.999"
"1971-03-31 00:00:00"
"1971-03-31 23:59:59.999"
"1971-04-01 00:00:00"
"1971-04-01 23:59:59.999"
"1971-04-02 00:00:00"
"1971-04-02 23:59:59.999"
"1971-04-03 00:00:00"
"1971-04-03 23:59:59.999"
"1971-04-04 00:00:00"
"1971-04-04 23:59:59.999"
"1971-04-05 00:00:00"
"1971-04-05 23:59:59.999"
"1971-04-06 00:00:00"
"1971-04-06 23:59:59.999"
"1971-04-07 00:00:00"
"1971-04-07 23:59:59.999"
"1971-04-08 00:00:00"
"1971-04-08 23:59:59.999"
"1971-04-09 00:00:00"
"1971-04-09 23:59:59.999"
"1971-04-10 00:00:00"
"1971-04-10 23:59:59.999"
"1971-04-11 00:00:00"
"1971-04-11 23:59:59.999"
"1971-04-12 00:00:00"
"1971-04-12 23:59:59.999"
"1971-04-13 00:00:00"
"1971-04-13 23:59:59.999"
"1971-04-14 00:00:00"
"1971-04-14 23:59:59.999"
"1971-04-15 00:00:00"
"1971-04-15 23:59:59.999"
"1971-04-16 00:00:00"
"1971-04-16 23:59:59.999"
"1971-04-17 00:00:00"
"1971-04-17 23:59:59.999"
"1971-04-18 00:00:00"
"1971-04-18 23:59:59.999"
"1971-04-19 00:00:00"
"1971-04-19 23:59:59.999"
"1971-04-20 00:00:00"
"1971-04-20 23:59:59.999"
"1971-04-21 00:00:00"
"1971-04-21 23:59:59.999"
"1971-04-22 00:00:00"
"1971-04-22 23:59:59.999"
"1971-04-23 00:00:00"
"1971-04-23 23:59:59.999"
"1971-04-24 00:00:00"
"1971-04-24 23:59:59.999"
"1971-04-25 00:00:00"
"1971-04-25 23:59:59.999"
"1971-04-26 00:00:00"
"1971-04-26 23:59:59.999"
"1971-04-27 00:00:00"
"1971-04-27 23:59:59.999"
"1971-04-28 00:00:00"
"1971-04-28 23:59:59.999"
"1971-04-29 00:00:00"
"1971-04-29 23:59:59.999"
"1971-04-30 00:00:00"
"1971-04-30 23:59:59.999"
"1971-05-01 00:00:00"
"1971-05-01 23:59:59.999"
"1971-05-01 00:00:00"
"1971-05-01 23:59:59.999"
"1971-05-02 00:00:00"
"1971-05-02 23:59:59.999"
"1971-05-03 00:00:00"
"1971-05-03 23:59:59.999"
"1971-05-04 00:00:00"
"1971-05-04 23:59:59.999"
"1971-05-05 00:00:00"
"1971-05-05 23:59:59.999"
"1971-05-06 00:00:00"
"1971-05-06 23:59:59.999"
"1971-05-07 00:00:00"
"1971-05-07 23:59:59.999"
"1971-05-08 00:00:00"
"1971-05-08 23:59:59.999"
"1971-05-09 00:00:00"
"1971-05-09 23:59:59.999"
"1971-05-10 00:00:00"
"1971-05-10 23:59:59.999"
"1971-05-11 00:00:00"
"1971-05-11 23:59:59.999"
"1971-05-12 00:00:00"
"1971-05-12 23:59:59.999"
"1971-05-13 00:00:00"
"1971-05-13 23:59:59.999"
"1971-05-14 00:00:00"
"1971-05-14 23:59:59.999"
"1971-05-15 00:00:00"
"1971-05-15 23:59:59.999"
"1971-05-16 00:00:00"
"1971-05-16 23:59:59.999"
"1971-05-17 00:00:00"
"1971-05-17 23:59:59.999"
"1971-05-18 00:00:00"
"1971-05-18 23:59:59.999"
"1971-05-19 00:00:00"
"1971-05-19 23:59:59.999"
"1971-05-20 00:00:00"
"1971-05-20 23:59:59.999"
"1971-05-21 00:00:00"
"1971-05-21 23:59:59.999"
"1971-05-22 00:00:00"
"1971-05-22 23:59:59.999"
"1971-05-23 00:00:00"
"1971-05-23 23:59:59.999"
"1971-05-24 00:00:00"
"1971-05-24 23:59:59.999"
"1971-05-25 00:00:00"
"1971-05-25 23:59:59.999"
"1971-05-26 00:00:00"
"1971-05-26 23:59:59.999"
"1971-05-27 00:00:00"
"1971-05-27 23:59:59.999"
"1971-05-28 00:00:00"
"1971-05-28 23:59:59.999"
"1971-05-29 00:00:00"
"1971-05-29 23:59:59.999"
"1971-05-30 00:00:00"
"1971-05-30 23:59:59.999"
"1971-05-31 00:00:00"
"1971-05-31 23:59:59.999"
"1971-06-01 00:00:00"
"1971-06-01 23:59:59.999"
"1971-06-02 00:00:00"
"1971-06-02 23:59:59.999"
"1971-06-03 00:00:00"
"1971-06-03 23:59:59.999"
"1971-06-04 00:00:00"
"1971-06-04 23:59:59.999"
"1971-06-05 00:00:00"
"1971-06-05 23:59:59.999"
"1971-06-06 00:00:00"
"1971-06-06 23:59:59.999"
"1971-06-07 00:00:00"
"1971-06-07 23:59:59.999"
"1971-06-08 00:00:00"
"1971-06-08 23:59:59.999"
"1971-06-09 00:00:00"
"1971-06-09 23:59:59.999"
"1971-06-10 00:00:00"
"1971-06-10 23:59:59.999"
"1971-06-11 00:00:00"
"1971-06-11 23:59:59.999"
"1971-06-12 00:00:00"
"1971-06-12 23:59:59.999"
"1971-06-13 00:00:00"
"1971-06-13 23:59:59.999"
"1971-06-14 00:00:00"
"1971-06-14 23:59:59.999"
"1971-06-15 00:00:00"
"1971-06-15 23:59:59.999"
"1971-06-16 00:00:00"
"1971-06-16 23:59:59.999"
"1971-06-17 00:00:00"
"1971-06-17 23:59:59.999"
"1971-06-18 00:00:00"
"1971-06-18 23:59:59.999"
"1971-06-19 00:00:00"
"1971-06-19 23:59:59.999"
"1971-06-20 00:00:00"
"1971-06-20 23:59:59.999"
"1971-06-21 00:00:00"
"1971-06-21 23:59:59.999"
"1971-06-22 00:00:00"
"1971-06-22 23:59:59.999"
"1971-06-23 00:00:00"
"1971-06-23 23:59:59.999"
"1971-06-24 00:00:00"
"1971-06-24 23:59:59.999"
"1971-06-25 00:00:00"
"1971-06-25 23:59:59.999"
"1971-06-26 00:00:00"
"1971-06-26 23:59:59.999"
"1971-06-27 00:00:00"
"1971-06-27 23:59:59.999"
"1971-06-28 00:00:00"
"1971-06-28 23:59:59.999"
"1971-06-29 00:00:00"
"1971-06-29 23:59:59.999"
"1971-06-30 00:00:00"
"1971-06-30 23:59:59.999"
"1971-07-01 00:00:00"
"1971-07-01 23:59:59.999"
"1971-07-01 00:00:00"
"1971-07-01 23:59:59.999"
"1971-07-02 00:00:00"
"1971-07-02 23:59:59.999"
"1971-07-03 00:00:00"
"1971-07-03 23:59:59.999"
"1971-07-04 00:00:00"
"1971-07-04 23:59:59.999"
"1971-07-05 00:00:00"
"1971-07-05 23:59:59.999"
"1971-07-06 00:00:00"
"1971-07-06 23:59:59.999"
"1971-07-07 00:00:00"
"1971-07-07 23:59:59.999"
"1971-07-08 00:00:00"
"1971-07-08 23:59:59.999"
"1971-07-09 00:00:00"
"1971-07-09 23:59:59.999"
"1971-07-10 00:00:00"
"1971-07-10 23:59:59.999"
"1971-07-11 00:00:00"
"1971-07-11 23:59:59.999"
"1971-07-12 00:00:00"
"1971-07-12 23:59:59.999"
"1971-07-13 00:00:00"
"1971-07-13 23:59:59.999"
"1971-07-14 00:00:00"
"1971-07-14 23:59:59.999"
"1971-07-15 00:00:00"
"1971-07-15 23:59:59.999"
"1971-07-16 00:00:00"
"1971-07-16 23:59:59.999"
"1971-07-17 00:00:00"
"1971-07-17 23:59:59.999"
"1971-07-18 00:00:00"
"1971-07-18 23:59:59.999"
"1971-07-19 00:00:00"
"1971-07-19 23:59:59.999"
"1971-07-20 00:00:00"
"1971-07-20 23:59:59.999"
"1971-07-21 00:00:00"
"1971-07-21 23:59:59.999"
"1971-07-22 00:00:00"
"1971-07-22 23:59:59.999"
"1971-07-23 00:00:00"
"1971-07-23 23:59:59.999"
"1971-07-24 00:00:00"
"1971-07-24 23:59:59.999"
"1971-07-25 00:00:00"
"1971-07-25 23:59:59.999"
"1971-07-26 00:00:00"
"1971-07-26 23:59:59.999"
"1971-07-27 00:00:00"
"1971-07-27 23:59:59.999"
"1971-07-28 00:00:00"
"1971-07-28 23:59:59.999"
"1971-07-29 00:00:00"
"1971-07-29 23:59:59.999"
"1971-07-30 00:00:00"
"1971-07-30 23:59:59.999"
"1971-07-31 00:00:00"
"1971-07-31 23:59:59.999"
"1971-08-01 00:00:00"
"1971-08-01 23:59:59.999"
"1971-08-02 00:00:00"
"1971-08-02 23:59:59.999"
"1971-08-03 00:00:00"
"1971-08-03 23:59:59.999"
"1971-08-04 00:00:00"
"1971-08-04 23:59:59.999"
"1971-08-05 00:00:00"
"1971-08-05 23:59:59.999"
"1971-08-06 00:00:00"
"1971-08-06 23:59:59.999"
"1971-08-07 00:00:00"
"1971-08-07 23:59:59.999"
"1971-08-08 00:00:00"
"1971-08-08 23:59:59.999"
"1971-08-09 00:00:00"
"1971-08-09 23:59:59.999"
"1971-08-10 00:00:00"
"1971-08-10 23:59:59.999"
"1971-08-11 00:00:00"
"1971-08-11 23:59:59.999"
"1971-08-12 00:00:00"
"1971-08-12 23:59:59.999"
"1971-08-13 00:00:00"
"1971-08-13 23:59:59.999"
"1971-08-14 00:00:00"
"1971-08-14 23:59:59.999"
"1971-08-15 00:00:00"
"1971-08-15 23:59:59.999"
"1971-08-16 00:00:00"
"1971-08-16 23:59:59.999"
"1971-08-17 00:00:00"
"1971-08-17 23:59:59.999"
"1971-08-18 00:00:00"
"1971-08-18 23:59:59.999"
"1971-08-19 00:00:00"
"1971-08-19 23:59:59.999"
"1971-08-20 00:00:00"
"1971-08-20 23:59:59.999"
"1971-08-21 00:00:00"
"1971-08-21 23:59:59.999"
"1971-08-22 00:00:00"
"1971-08-22 23:59:59.999"
"1971-08-23 00:00:00"
"1971-08-23 23:59:59.999"
"1971-08-24 00:00:00"
"1971-08-24 23:59:59.999"
"1971-08-25 00:00:00"
"1971-08-25 23:59:59.999"
"1971-08-26 00:00:00"
"1971-08-26 23:59:59.999"
"1971-08-27 00:00:00"
"1971-08-27 23:59:59.999"
"1971-08-28 00:00:00"
"1971-08-28 23:59:59.999"
"1971-08-29 00:00:00"
"1971-08-29 23:59:59.999"
"1971-08-30 00:00:00"
"1971-08-30 23:59:59.999"
"1971-08-31 00:00:00"
"1971-08-31 23:59:59.999"
"1971-09-01 00:00:00"
"1971-09-01 23:59:59.999"
"1971-09-02 00:00:00"
"1971-09-02 23:59:59.999"
"1971-09-03 00:00:00"
"1971-09-03 23:59:59.999"
"1971-09-04 00:00:00"
"1971-09-04 23:59:59.999"
"1971-09-05 00:00:00"
"1971-09-05 23:59:59.999"
"1971-09-06 00:00:00"
"1971-09-06 23:59:59.999"
"1971-09-07 00:00:00"
"1971-09-07 23:59:59.999"
"1971-09-08 00:00:00"
"1971-09-08 23:59:59.999"
"1971-09-09 00:00:00"
"1971-09-09 23:59:59.999"
"1971-09-10 00:00:00"
"1971-09-10 23:59:59.999"
"1971-09-11 00:00:00"
"1971-09-11 23:59:59.999"
"1971-09-12 00:00:00"
"1971-09-12 23:59:59.999"
"1971-09-13 00:00:00"
"1971-09-13 23:59:59.999"
"1971-09-14 00:00:00"
"1971-09-14 23:59:59.999"
"1971-09-15 00:00:00"
"1971-09-15 23:59:59.999"
"1971-09-16 00:00:00"
"1971-09-16 23:59:59.999"
"1971-09-17 00:00:00"
"1971-09-17 23:59:59.999"
"1971-09-18 00:00:00"
"1971-09-18 23:59:59.999"
"1971-09-19 00:00:00"
"1971-09-19 23:59:59.999"
"1971-09-20 00:00:00"
"1971-09-20 23:59:59.999"
"1971-09-21 00:00:00"
"1971-09-21 23:59:59.999"
"1971-09-22 00:00:00"
"1971-09-22 23:59:59.999"
"1971-09-23 00:00:00"
"1971-09-23 23:59:59.999"
"1971-09-24 00:00:00"
"1971-09-24 23:59:59.999"
"1971-09-25 00:00:00"
"1971-09-25 23:59:59.999"
"1971-09-26 00:00:00"
"1971-09-26 23:59:59.999"
"1971-09-27 00:00:00"
"1971-09-27 23:59:59.999"
"1971-09-28 00:00:00"
"1971-09-28 23:59:59.999"
"1971-09-29 00:00:00"
"1971-09-29 23:59:59.999"
"1971-09-30 00:00:00"
"1971-09-30 23:59:59.999"
"1971-10-01 00:00:00"
"1971-10-01 23:59:59.999"
"1971-10-01 00:00:00"
"1971-10-01 23:59:59.999"
"1971-10-02 00:00:00"
"1971-10-02 23:59:59.999"
"1971-10-03 00:00:00"
"1971-10-03 23:59:59.999"
"1971-10-04 00:00:00"
"1971-10-04 23:59:59.999"
"1971-10-05 00:00:00"
"1971-10-05 23:59:59.999"
"1971-10-06 00:00:00"
"1971-10-06 23:59:59.999"
"1971-10-07 00:00:00"
"1971-10-07 23:59:59.999"
"1971-10-08 00:00:00"
"1971-10-08 23:59:59.999"
"1971-10-09 00:00:00"
"1971-10-09 23:59:59.999"
"1971-10-10 00:00:00"
"1971-10-10 23:59:59.999"
"1971-10-11 00:00:00"
"1971-10-11 23:59:59.999"
"1971-10-12 00:00:00"
"1971-10-12 23:59:59.999"
"1971-10-13 00:00:00"
"1971-10-13 23:59:59.999"
"1971-10-14 00:00:00"
"1971-10-14 23:59:59.999"
"1971-10-15 00:00:00"
"1971-10-15 23:59:59.999"
"1971-10-16 00:00:00"
"1971-10-16 23:59:59.999"
"1971-10-17 00:00:00"
"1971-10-17 23:59:59.999"
"1971-10-18 00:00:00"
"1971-10-18 23:59:59.999"
"1971-10-19 00:00:00"
"1971-10-19 23:59:59.999"
"1971-10-20 00:00:00"
"1971-10-20 23:59:59.999"
"1971-10-21 00:00:00"
"1971-10-21 23:59:59.999"
"1971-10-22 00:00:00"
"1971-10-22 23:59:59.999"
"1971-10-23 00:00:00"
"1971-10-23 23:59:59.999"
"1971-10-24 00:00:00"
"1971-10-24 23:59:59.999"
"1971-10-25 00:00:00"
"1971-10-25 23:59:59.999"
"1971-10-26 00:00:00"
"1971-10-26 23:59:59.999"
"1971-10-27 00:00:00"
"1971-10-27 23:59:59.999"
"1971-10-28 00:00:00"
"1971-10-28 23:59:59.999"
"1971-10-29 00:00:00"
"1971-10-29 23:59:59.999"
"1971-10-30 00:00:00"
"1971-10-30 23:59:59.999"
"1971-10-31 00:00:00"
"1971-10-31 23:59:59.999"
"1971-11-01 00:00:00"
"1971-11-01 23:59:59.999"
"1971-11-02 00:00:00"
"1971-11-02 23:59:59.999"
"1971-11-03 00:00:00"
"1971-11-03 23:59:59.999"
"1971-11-04 00:00:00"
"1971-11-04 23:59:59.999"
"1971-11-05 00:00:00"
"1971-11-05 23:59:59.999"
"1971-11-06 00:00:00"
"1971-11-06 23:59:59.999"
"1971-11-07 00:00:00"
"1971-11-07 23:59:59.999"
"1971-11-08 00:00:00"
"1971-11-08 23:59:59.999"
"1971-11-09 00:00:00"
"1971-11-09 23:59:59.999"
"1971-11-10 00:00:00"
"1971-11-10 23:59:59.999"
"1971-11-11 00:00:00"
"1971-11-11 23:59:59.999"
"1971-11-12 00:00:00"
"1971-11-12 23:59:59.999"
"1971-11-13 00:00:00"
"1971-11-13 23:59:59.999"
"1971-11-14 00:00:00"
"1971-11-14 23:59:59.999"
"1971-11-15 00:00:00"
"1971-11-15 23:59:59.999"
"1971-11-16 00:00:00"
"1971-11-16 23:59:59.999"
"1971-11-17 00:00:00"
"1971-11-17 23:59:59.999"
"1971-11-18 00:00:00"
"1971-11-18 23:59:59.999"
"1971-11-19 00:00:00"
"1971-11-19 23:59:59.999"
"1971-11-20 00:00:00"
"1971-11-20 23:59:59.999"
"1971-11-21 00:00:00"
"1971-11-21 23:59:59.999"
"1971-11-22 00:00:00"
"1971-11-22 23:59:59.999"
"1971-11-23 00:00:00"
"1971-11-23 23:59:59.999"
"1971-11-24 00:00:00"
"1971-11-24 23:59:59.999"
"1971-11-25 00:00:00"
"1971-11-25 23:59:59.999"
"1971-11-26 00:00:00"
"1971-11-26 23:59:59.999"
"1971-11-27 00:00:00"
"1971-11-27 23:59:59.999"
"1971-11-28 00:00:00"
"1971-11-28 23:59:59.999"
"1971-11-29 00:00:00"
"1971-11-29 23:59:59.999"
"1971-11-30 00:00:00"
"1971-11-30 23:59:59.999"
"1971-12-01 00:00:00"
"1971-12-01 23:59:59.999"
"1971-12-01 00:00:00"
"1971-12-01 23:59:59.999"
"1971-12-02 00:00:00"
"1971-12-02 23:59:59.999"
"1971-12-03 00:00:00"
"1971-12-03 23:59:59.999"
"1971-12-04 00:00:00"
"1971-12-04 23:59:59.999"
"1971-12-05 00:00:00"
"1971-12-05 23:59:59.999"
"1971-12-06 00:00:00"
"1971-12-06 23:59:59.999"
"1971-12-07 00:00:00"
"1971-12-07 23:59:59.999"
"1971-12-08 00:00:00"
"1971-12-08 23:59:59.999"
"1971-12-09 00:00:00"
"1971-12-09 23:59:59.999"
"1971-12-10 00:00:00"
"1971-12-10 23:59:59.999"
"1971-12-11 00:00:00"
"1971-12-11 23:59:59.999"
"1971-12-12 00:00:00"
"1971-12-12 23:59:59.999"
"1971-12-13 00:00:00"
"1971-12-13 23:59:59.999"
"1971-12-14 00:00:00"
"1971-12-14 23:59:59.999"
"1971-12-15 00:00:00"
"1971-12-15 23:59:59.999"
"1971-12-16 00:00:00"
"1971-12-16 23:59:59.999"
"1971-12-17 00:00:00"
"1971-12-17 23:59:59.999"
"1971-12-18 00:00:00"
"1971-12-18 23:59:59.999"
"1971-12-19 00:00:00"
"1971-12-19 23:59:59.999"
"1971-12-20 00:00:00"
"1971-12-20 23:59:59.999"
"1971-12-21 00:00:00"
"1971-12-21 23:59:59.999"
"1971-12-22 00:00:00"
"1971-12-22 23:59:59.999"
"1971-12-23 00:00:00"
"1971-12-23 23:59:59.999"
"1971-12-24 00:00:00"
"1971-12-24 23:59:59.999"
"1971-12-25 00:00:00"
"1971-12-25 23:59:59.999"
"1971-12-26 00:00:00"
"1971-12-26 23:59:59.999"
"1971-12-27 00:00:00"
"1971-12-27 23:59:59.999"
"1971-12-28 00:00:00"
"1971-12-28 23:59:59.999"
"1971-12-29 00:00:00"
"1971-12-29 23:59:59.999"
"1971-12-30 00:00:00"
"1971-12-30 23:59:59.999"
"1971-12-31 00:00:00"
"1971-12-31 23:59:59.999"
"1972-01-01 00:00:00"
"1972-01-01 23:59:59.999"
"1972-01-02 00:00:00"
"1972-01-02 23:59:59.999"

On Dec 4, 2006, at 23:52 , Ronin wrote:

> Hi when I do the following function it fills 2 dates per day from 1970
> to 2050, except that some months (typical 2 months per year) have 4
> dates for one day. this is totally freaky.. I wonder if postgresql is
> tripping over itself making a double entry every now and again.
>
> for instance I constantly get the following entries
>
> "2006-10-01 00:00:00"
> "2006-10-01 23:59:59.999"
> "2006-10-01 00:00:00"
> "2006-10-01 23:59:59.999"
>
> Any ideas?
>
> Here the function
>
> DECLARE
> yearcnt integer;
> monthcnt integer;
> daycnt integer;
>
> BEGIN
>
> FOR yearcnt IN 1970..2050 LOOP
> monthcnt=1;
> FOR monthcnt IN 1..12 LOOP
> daycnt = 1;
> FOR daycnt IN 1..31 LOOP
> insert into datepool values
> (to_timestamp(yearcnt||'-'||to_char(monthcnt,'FM00')||'-'||to_char
> (daycnt,'FM09')||'
> 00:00:00.000','YYYY MM DD HH24:MI:SS.MS'));
>
> insert into datepool values
> (to_timestamp(yearcnt||'-'||to_char(monthcnt,'FM00')||'-'||to_char
> (daycnt,'FM09')||'
> 23:59:59.999','YYYY MM DD HH24:MI:SS.MS'));
>
>
> END LOOP;
> END LOOP;
> END LOOP;
>
> return;
>
> END;


I think both Martijn and Csaba have the right idea. Here's an
alternative that should work around those issues:

create table datepool(pool_ts timestamp primary key);

create function fill_date_range(start_date date, end_date date)
returns void
language plpgsql as $func$
declare
this_date date;
begin
this_date := start_date;
loop
insert into datepool(pool_ts) values (this_date);
insert into datepool(pool_ts) values ((this_date +
1)::timestamp - interval '.001 second');
exit when this_date >= end_date;
this_date := this_date + 1;
end loop;
return;
end;
$func$;

select fill_date_range('1970-01-01','2050-12-31');

# select * from datepool where pool_ts >= '2006-10-01' limit 10;
pool_ts
-------------------------
2006-10-01 00:00:00
2006-10-01 23:59:59.999
2006-10-02 00:00:00
2006-10-02 23:59:59.999
2006-10-03 00:00:00
2006-10-03 23:59:59.999
2006-10-04 00:00:00
2006-10-04 23:59:59.999
2006-10-05 00:00:00
2006-10-05 23:59:59.999
(10 rows)

Hope that helps.

Michael Glaesemann
grzm seespotcode net



---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?

http://archives.postgresql.org/

sweet that worked!

thanks

Michael Glaesemann wrote:
> On Dec 4, 2006, at 23:52 , Ronin wrote:
>
> > Hi when I do the following function it fills 2 dates per day from 1970
> > to 2050, except that some months (typical 2 months per year) have 4
> > dates for one day. this is totally freaky.. I wonder if postgresql is
> > tripping over itself making a double entry every now and again.
> >
> > for instance I constantly get the following entries
> >
> > "2006-10-01 00:00:00"
> > "2006-10-01 23:59:59.999"
> > "2006-10-01 00:00:00"
> > "2006-10-01 23:59:59.999"
> >
> > Any ideas?
> >
> > Here the function
> >
> > DECLARE
> > yearcnt integer;
> > monthcnt integer;
> > daycnt integer;
> >
> > BEGIN
> >
> > FOR yearcnt IN 1970..2050 LOOP
> > monthcnt=1;
> > FOR monthcnt IN 1..12 LOOP
> > daycnt = 1;
> > FOR daycnt IN 1..31 LOOP
> > insert into datepool values
> > (to_timestamp(yearcnt||'-'||to_char(monthcnt,'FM00')||'-'||to_char
> > (daycnt,'FM09')||'
> > 00:00:00.000','YYYY MM DD HH24:MI:SS.MS'));
> >
> > insert into datepool values
> > (to_timestamp(yearcnt||'-'||to_char(monthcnt,'FM00')||'-'||to_char
> > (daycnt,'FM09')||'
> > 23:59:59.999','YYYY MM DD HH24:MI:SS.MS'));
> >
> >
> > END LOOP;
> > END LOOP;
> > END LOOP;
> >
> > return;
> >
> > END;
>
>
> I think both Martijn and Csaba have the right idea. Here's an
> alternative that should work around those issues:
>
> create table datepool(pool_ts timestamp primary key);
>
> create function fill_date_range(start_date date, end_date date)
> returns void
> language plpgsql as $func$
> declare
> this_date date;
> begin
> this_date := start_date;
> loop
> insert into datepool(pool_ts) values (this_date);
> insert into datepool(pool_ts) values ((this_date +
> 1)::timestamp - interval '.001 second');
> exit when this_date >= end_date;
> this_date := this_date + 1;
> end loop;
> return;
> end;
> $func$;
>
> select fill_date_range('1970-01-01','2050-12-31');
>
> # select * from datepool where pool_ts >= '2006-10-01' limit 10;
> pool_ts
> -------------------------
> 2006-10-01 00:00:00
> 2006-10-01 23:59:59.999
> 2006-10-02 00:00:00
> 2006-10-02 23:59:59.999
> 2006-10-03 00:00:00
> 2006-10-03 23:59:59.999
> 2006-10-04 00:00:00
> 2006-10-04 23:59:59.999
> 2006-10-05 00:00:00
> 2006-10-05 23:59:59.999
> (10 rows)
>
> Hope that helps.
>
> Michael Glaesemann
> grzm seespotcode net
>
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 4: Have you searched our list archives?
>
> http://archives.postgresql.org/