Vamos lá...
DDL da tabela
CREATE TABLE "public"."r905_acompviagem" (
"seq" SERIAL,
"carro" VARCHAR(20) NOT NULL,
"codrota" VARCHAR(20),
"datasaida" TIMESTAMP WITHOUT TIME ZONE NOT NULL,
"pernoites" INTEGER DEFAULT 0 NOT NULL,
"dtprevret" TIMESTAMP WITHOUT TIME ZONE,
"retornado" CHAR(1) DEFAULT 'N'::bpchar,
"codusucad" INTEGER NOT NULL,
"datacad" TIMESTAMP WITHOUT TIME ZONE DEFAULT now(),
"seq904" INTEGER,
"tipo" CHAR(1),
"codmotorista" INTEGER,
"codajudante1" INTEGER,
"codajudante2" INTEGER,
"dataretorno" TIMESTAMP WITHOUT TIME ZONE,
"codusuret" INTEGER,
"codtelefone" INTEGER,
"unifmot" CHAR(1) DEFAULT 'N'::bpchar,
"unifajud1" CHAR(1) DEFAULT 'N'::bpchar,
"unifajud2" CHAR(1) DEFAULT 'N'::bpchar,
"carrolimpo" CHAR(1) DEFAULT 'S'::bpchar,
"motretdef" CHAR(1) DEFAULT 'S'::bpchar,
"ajud1retdef" CHAR(1) DEFAULT 'S'::bpchar,
"ajud2retdef" CHAR(2) DEFAULT 'S'::bpchar,
"caixafechado" CHAR(1) DEFAULT 'N'::bpchar,
"codusufechacaixa" INTEGER,
"datafechacaixa" TIMESTAMP WITHOUT TIME ZONE,
"retroativo" CHAR(1) DEFAULT 'N'::bpchar,
CONSTRAINT "pk_905_acompviagem" PRIMARY KEY("seq"),
CONSTRAINT "fk_905_acompviagem_usucad" FOREIGN KEY ("codusucad")
REFERENCES "public"."usuarios"("seq")
ON DELETE NO ACTION
ON UPDATE CASCADE
NOT DEFERRABLE
) WITHOUT OIDS
TABLESPACE "ts_dados";
Select :
select a.seq,
a.datasaida,
a.dataretorno
from r905_acompviagem a
where a.datasaida::date >= '01/12/2010'
and a.dataretorno::date <= '31/12/2010'
order by a.datasaida
Saida de dados:
seq datasaida dataretorno
243 05/04/2010 08:51:19 05/04/2010 08:51:18
247 05/04/2010 09:06:52 05/04/2010 09:06:52
253 05/04/2010 10:24:33 05/04/2010 10:24:33
254 05/04/2010 11:06:49 05/04/2010 11:06:48
255 05/04/2010 11:07:20 05/04/2010 11:07:20
257 05/04/2010 12:13:03 05/04/2010 12:13:03
258 06/04/2010 07:29:19 06/04/2010 07:29:18
259 06/04/2010 07:33:45 06/04/2010 07:33:44
260 06/04/2010 07:36:39 06/04/2010 07:36:38
261 06/04/2010 07:37:34 06/04/2010 07:37:33
262 06/04/2010 08:45:33 06/04/2010 08:45:32
263 06/04/2010 08:46:26 06/04/2010 08:46:26
264 06/04/2010 08:46:39 06/04/2010 08:46:39
265 06/04/2010 08:47:12 06/04/2010 08:47:11
266 06/04/2010 08:48:18 06/04/2010 08:48:17
267 06/04/2010 08:57:41 06/04/2010 08:57:40
268 06/04/2010 09:18:17 06/04/2010 09:18:16
269 06/04/2010 10:18:01 06/04/2010 10:18:00
270 07/04/2010 09:20:47 07/04/2010 09:20:47
275 07/04/2010 10:56:13 07/04/2010 10:56:12
271 07/04/2010 11:03:22 07/04/2010 11:03:22
272 07/04/2010 11:05:32 07/04/2010 11:05:32
273 07/04/2010 11:07:57 07/04/2010 11:07:56
274 07/04/2010 11:09:33 07/04/2010 11:09:33
276 07/04/2010 11:29:36 07/04/2010 11:29:35
277 07/04/2010 11:31:03 07/04/2010 11:31:03
278 07/04/2010 11:31:17 07/04/2010 11:31:17
279 07/04/2010 11:31:25 07/04/2010 11:31:24
280 07/04/2010 11:31:54 07/04/2010 11:31:54
281 07/04/2010 11:32:06 07/04/2010 11:32:05
282 07/04/2010 11:32:18 07/04/2010 11:32:18
283 08/04/2010 06:46:12 08/04/2010 06:46:12
284 08/04/2010 08:12:43 08/04/2010 08:12:43
285 08/04/2010 08:17:59 08/04/2010 08:17:59
286 08/04/2010 08:18:14 08/04/2010 08:18:13
287 08/04/2010 08:18:30 08/04/2010 08:18:30
288 08/04/2010 08:18:51 08/04/2010 08:18:51
289 08/04/2010 08:32:57 08/04/2010 08:32:57
290 08/04/2010 08:35:18 08/04/2010 08:35:18
295 08/04/2010 08:36:16 08/04/2010 08:36:16
291 08/04/2010 08:44:37 08/04/2010 08:44:36
292 08/04/2010 08:47:48 08/04/2010 08:47:48
293 08/04/2010 08:48:03 08/04/2010 08:48:03
294 08/04/2010 09:14:10 08/04/2010 09:14:09
296 08/04/2010 09:32:51 08/04/2010 09:32:50
297 09/04/2010 07:48:56 09/04/2010 07:48:56
298 09/04/2010 07:49:59 09/04/2010 07:49:58
299 09/04/2010 08:16:23 09/04/2010 08:16:23
303 09/04/2010 08:18:54 09/04/2010 08:18:54
300 09/04/2010 08:26:38 09/04/2010 08:26:38
301 09/04/2010 08:31:23 09/04/2010 08:31:22
302 09/04/2010 08:31:46 09/04/2010 08:31:46
304 09/04/2010 08:33:25 09/04/2010 08:33:24
305 09/04/2010 08:41:29 09/04/2010 08:41:29
306 09/04/2010 09:41:31 09/04/2010 09:41:30
307 09/04/2010 09:42:03 09/04/2010 09:42:03
308 09/04/2010 09:43:12 09/04/2010 09:43:11
309 09/04/2010 09:43:42 09/04/2010 09:43:41
310 09/04/2010 09:43:54 09/04/2010 09:43:53
311 09/04/2010 11:23:13 09/04/2010 11:23:13
312 12/04/2010 07:43:00 12/04/2010 07:42:59
313 12/04/2010 09:18:05 12/04/2010 09:18:05
314 12/04/2010 09:20:40 12/04/2010 09:20:40
315 12/04/2010 09:29:12 12/04/2010 09:29:12
316 12/04/2010 09:29:35 12/04/2010 09:29:34
317 12/04/2010 09:31:10 12/04/2010 09:31:09
318 12/04/2010 09:31:25 12/04/2010 09:31:24
319 12/04/2010 11:22:20 12/04/2010 11:22:20
326 12/04/2010 11:28:40 12/04/2010 11:28:40
327 12/04/2010 12:50:57 12/04/2010 12:50:56
328 13/04/2010 07:53:17 13/04/2010 07:53:16
329 13/04/2010 07:56:20 13/04/2010 07:56:20
337 13/04/2010 08:05:44 13/04/2010 08:05:44
330 13/04/2010 10:34:38 13/04/2010 10:34:37
331 13/04/2010 10:34:48 13/04/2010 10:34:47
332 13/04/2010 10:35:28 13/04/2010 10:35:27
333 13/04/2010 10:35:45 13/04/2010 10:35:45
334 13/04/2010 10:36:22 13/04/2010 10:36:22
335 13/04/2010 10:36:54 13/04/2010 10:36:53
336 13/04/2010 10:43:05 13/04/2010 10:43:05
338 13/04/2010 10:53:18 13/04/2010 10:53:17
339 13/04/2010 11:04:47 13/04/2010 11:04:47
342 14/04/2010 07:49:35 14/04/2010 07:49:35
340 14/04/2010 08:55:01 14/04/2010 08:55:01
341 14/04/2010 08:56:10 14/04/2010 08:56:10
351 14/04/2010 09:02:19 14/04/2010 09:02:18
343 14/04/2010 09:12:11 14/04/2010 09:12:10
344 14/04/2010 09:12:32 14/04/2010 09:12:31
345 14/04/2010 09:12:37 14/04/2010 09:12:36
346 14/04/2010 09:13:28 14/04/2010 09:13:27
347 14/04/2010 09:13:34 14/04/2010 09:13:34
348 14/04/2010 09:13:56 14/04/2010 09:13:55
349 14/04/2010 09:17:01 14/04/2010 09:17:00
350 14/04/2010 09:36:23 14/04/2010 09:36:23
352 14/04/2010 10:29:08 14/04/2010 10:29:08
353 14/04/2010 10:30:05 14/04/2010 10:30:04
354 14/04/2010 10:31:40 14/04/2010 10:31:40
355 15/04/2010 06:59:04 15/04/2010 06:59:04
356 15/04/2010 07:56:17 15/04/2010 07:56:16
357 15/04/2010 07:56:41 15/04/2010 07:56:41
358 15/04/2010 08:03:30 15/04/2010 08:03:29
359 15/04/2010 08:19:45 15/04/2010 08:19:44
360 15/04/2010 08:30:13 15/04/2010 08:30:12
361 15/04/2010 08:32:25 15/04/2010 08:32:25
363 15/04/2010 08:50:40 15/04/2010 08:50:39
362 15/04/2010 08:55:01 15/04/2010 08:55:00
364 15/04/2010 10:06:04 15/04/2010 10:06:04
365 15/04/2010 10:11:56 15/04/2010 10:11:56
366 15/04/2010 10:12:33 15/04/2010 10:12:32
367 15/04/2010 10:13:01 15/04/2010 10:13:01
368 15/04/2010 10:13:31 15/04/2010 10:13:30
369 15/04/2010 14:30:19 15/04/2010 14:30:18
370 16/04/2010 07:04:42 16/04/2010 07:04:42
371 16/04/2010 07:54:24 16/04/2010 07:54:24
372 16/04/2010 07:54:54 16/04/2010 07:54:53
381 16/04/2010 08:00:46 16/04/2010 08:00:46
373 16/04/2010 08:03:29 16/04/2010 08:03:28
374 16/04/2010 08:04:32 16/04/2010 08:04:31
375 16/04/2010 08:05:02 16/04/2010 08:05:02
376 16/04/2010 08:33:39 16/04/2010 08:33:39
377 16/04/2010 08:41:08 16/04/2010 08:41:08
378 16/04/2010 08:42:49 16/04/2010 08:42:49
379 16/04/2010 08:43:32 16/04/2010 08:43:32
380 16/04/2010 08:50:45 16/04/2010 08:50:44
389 19/04/2010 07:44:37 19/04/2010 07:44:36
390 19/04/2010 07:58:19 19/04/2010 07:58:19
391 19/04/2010 08:58:24 19/04/2010 08:58:23
392 19/04/2010 08:58:42 19/04/2010 08:58:42
393 19/04/2010 08:59:03 19/04/2010 08:59:03
396 19/04/2010 09:01:07 19/04/2010 09:01:07
397 19/04/2010 09:07:28 19/04/2010 09:07:27
398 19/04/2010 09:56:52 19/04/2010 09:56:51
418 19/04/2010 13:53:12 19/04/2010 13:53:12
450 20/04/2010 06:48:52 20/04/2010 06:48:52
451 20/04/2010 07:11:46 20/04/2010 07:11:45
453 20/04/2010 07:19:11 20/04/2010 07:19:11
452 20/04/2010 07:35:09 20/04/2010 07:35:08
454 20/04/2010 07:58:37 20/04/2010 07:58:36
455 20/04/2010 08:05:44 20/04/2010 08:05:44
456 20/04/2010 08:07:38 20/04/2010 08:07:38
459 20/04/2010 08:15:22 20/04/2010 08:15:21
457 20/04/2010 08:32:52 20/04/2010 08:32:51
458 20/04/2010 08:33:06 20/04/2010 08:33:05
460 20/04/2010 08:35:50 20/04/2010 08:35:50
461 20/04/2010 08:48:03 20/04/2010 08:48:02
462 20/04/2010 12:10:09 20/04/2010 12:10:09
463 22/04/2010 06:45:35 22/04/2010 06:45:34
464 22/04/2010 08:29:22 22/04/2010 08:29:22
465 22/04/2010 08:37:15 22/04/2010 08:37:14
466 22/04/2010 08:39:54 22/04/2010 08:39:54
467 22/04/2010 08:40:51 22/04/2010 08:40:50
468 22/04/2010 08:42:08 22/04/2010 08:42:07
471 22/04/2010 08:42:29 22/04/2010 08:42:28
469 22/04/2010 08:42:42 22/04/2010 08:42:42
470 22/04/2010 08:44:05 22/04/2010 08:44:04
472 22/04/2010 08:44:22 22/04/2010 08:44:21
473 22/04/2010 08:45:15 22/04/2010 08:45:15
486 22/04/2010 08:45:54 22/04/2010 08:45:53
477 22/04/2010 09:06:17 22/04/2010 09:06:17
480 22/04/2010 09:07:13 22/04/2010 09:07:13
483 22/04/2010 09:12:19 22/04/2010 09:12:18
484 22/04/2010 10:02:52 22/04/2010 10:02:52
487 22/04/2010 10:05:14 22/04/2010 10:05:13
500 22/04/2010 11:03:30 22/04/2010 11:03:29
519 22/04/2010 17:15:05 22/04/2010 17:15:05
522 23/04/2010 06:49:03 23/04/2010 06:49:02
520 23/04/2010 07:43:27 23/04/2010 07:43:27
521 23/04/2010 07:44:56 23/04/2010 07:44:55
524 23/04/2010 07:45:31 23/04/2010 07:45:31
523 23/04/2010 08:38:53 23/04/2010 08:38:53
525 23/04/2010 08:50:56 23/04/2010 08:50:56
526 23/04/2010 08:51:47 23/04/2010 08:51:47
527 23/04/2010 08:53:17 23/04/2010 08:53:17
528 23/04/2010 08:53:30 23/04/2010 08:53:30
529 23/04/2010 14:21:28 23/04/2010 14:21:28
530 26/04/2010 07:58:03 26/04/2010 07:58:02
532 26/04/2010 08:03:34 26/04/2010 08:03:33
539 26/04/2010 08:08:39 26/04/2010 08:08:39
533 26/04/2010 09:04:08 26/04/2010 09:04:07
534 26/04/2010 09:06:08 26/04/2010 09:06:08
535 26/04/2010 09:06:37 26/04/2010 09:06:36
536 26/04/2010 09:07:39 26/04/2010 09:07:38
537 26/04/2010 09:08:55 26/04/2010 09:08:54
538 26/04/2010 09:09:20 26/04/2010 09:09:20
540 26/04/2010 09:11:30 26/04/2010 09:11:29
541 26/04/2010 09:50:31 26/04/2010 09:50:30
542 26/04/2010 10:43:46 26/04/2010 10:43:45
546 26/04/2010 11:23:04 26/04/2010 11:23:04
548 26/04/2010 11:24:55 26/04/2010 11:24:54
550 27/04/2010 08:23:20 27/04/2010 08:23:19
551 27/04/2010 08:24:13 27/04/2010 08:24:12
552 27/04/2010 08:24:39 27/04/2010 08:24:39
553 27/04/2010 08:26:08 27/04/2010 08:26:07
554 27/04/2010 08:26:33 27/04/2010 08:26:33
555 27/04/2010 08:27:13 27/04/2010 08:27:13
556 27/04/2010 08:32:24 27/04/2010 08:32:24
557 27/04/2010 08:33:40 27/04/2010 08:33:39
558 27/04/2010 08:33:53 27/04/2010 08:33:52
559 27/04/2010 08:34:23 27/04/2010 08:34:23
560 27/04/2010 08:37:15 27/04/2010 08:37:15
561 27/04/2010 08:46:07 27/04/2010 08:46:07
562 27/04/2010 08:47:17 27/04/2010 08:47:17
563 27/04/2010 11:38:42 27/04/2010 11:38:41
564 28/04/2010 07:39:55 28/04/2010 07:39:54
565 28/04/2010 08:11:26 28/04/2010 08:11:26
566 28/04/2010 08:11:39 28/04/2010 08:11:38
567 28/04/2010 08:11:49 28/04/2010 08:11:48
568 28/04/2010 08:12:20 28/04/2010 08:12:20
569 28/04/2010 08:12:32 28/04/2010 08:12:31
577 28/04/2010 08:12:59 28/04/2010 08:12:59
572 28/04/2010 08:15:54 28/04/2010 08:15:53
576 28/04/2010 08:18:10 28/04/2010 08:18:09
578 28/04/2010 12:31:31 28/04/2010 12:31:30
579 28/04/2010 12:31:58 28/04/2010 12:31:58
580 29/04/2010 07:35:04 29/04/2010 07:35:04
581 29/04/2010 07:40:38 29/04/2010 07:40:37
582 29/04/2010 07:40:56 29/04/2010 07:40:56
583 29/04/2010 07:44:10 29/04/2010 07:44:10
584 29/04/2010 07:47:28 29/04/2010 07:47:28
585 29/04/2010 07:47:52 29/04/2010 07:47:52
586 29/04/2010 07:52:32 29/04/2010 07:52:31
587 29/04/2010 08:06:05 29/04/2010 08:06:05
588 29/04/2010 08:12:36 29/04/2010 08:12:36
589 29/04/2010 08:43:01 29/04/2010 08:43:01
590 29/04/2010 10:36:41 29/04/2010 10:36:41
591 29/04/2010 10:38:54 29/04/2010 10:38:53
592 29/04/2010 11:04:02 29/04/2010 11:04:02
593 29/04/2010 11:04:19 29/04/2010 11:04:19
607 30/04/2010 07:17:13 30/04/2010 07:17:12
594 30/04/2010 07:29:35 30/04/2010 07:29:34
595 30/04/2010 07:34:47 30/04/2010 07:34:46
596 30/04/2010 07:34:55 30/04/2010 07:34:55
597 30/04/2010 07:36:32 30/04/2010 07:36:31
598 30/04/2010 07:36:43 30/04/2010 07:36:43
599 30/04/2010 07:36:52 30/04/2010 07:36:52
600 30/04/2010 07:39:55 30/04/2010 07:39:55
601 30/04/2010 07:40:14 30/04/2010 07:40:13
602 30/04/2010 07:40:46 30/04/2010 07:40:45
603 30/04/2010 07:42:13 30/04/2010 07:42:13
604 30/04/2010 08:00:51 30/04/2010 08:00:51
605 30/04/2010 08:07:46 30/04/2010 08:07:46
606 30/04/2010 08:08:35 30/04/2010 08:08:34
608 30/04/2010 08:59:30 30/04/2010 08:59:30
609 03/05/2010 07:38:52 03/05/2010 07:38:51
610 03/05/2010 07:39:58 03/05/2010 07:39:58
611 03/05/2010 08:08:44 03/05/2010 08:08:43
612 03/05/2010 08:22:53 03/05/2010 08:22:52
613 03/05/2010 08:45:53 03/05/2010 08:45:52
614 03/05/2010 08:48:10 03/05/2010 08:48:09
616 03/05/2010 08:51:34 03/05/2010 08:51:33
617 03/05/2010 08:59:37 03/05/2010 08:59:36
623 03/05/2010 09:07:02 03/05/2010 09:07:02
624 03/05/2010 09:08:12 03/05/2010 09:08:12
626 03/05/2010 09:09:09 03/05/2010 09:09:08
627 04/05/2010 07:10:00 04/05/2010 07:10:00
628 04/05/2010 07:46:52 04/05/2010 07:46:51
629 04/05/2010 07:52:58 04/05/2010 07:52:58
630 04/05/2010 07:59:04 04/05/2010 07:59:04
631 04/05/2010 08:02:06 04/05/2010 08:02:05
632 04/05/2010 08:03:04 04/05/2010 08:03:03
633 04/05/2010 08:03:16 04/05/2010 08:03:16
634 04/05/2010 08:03:33 04/05/2010 08:03:33
635 04/05/2010 08:04:21 04/05/2010 08:04:21
636 04/05/2010 08:04:34 04/05/2010 08:04:34
639 05/05/2010 07:52:29 05/05/2010 07:52:29
640 05/05/2010 07:59:47 05/05/2010 07:59:47
641 05/05/2010 08:01:05 05/05/2010 08:01:05
642 05/05/2010 08:01:58 05/05/2010 08:01:57
643 05/05/2010 08:02:16 05/05/2010 08:02:15
644 05/05/2010 08:05:01 05/05/2010 08:05:01
645 05/05/2010 08:05:26 05/05/2010 08:05:25
647 05/05/2010 08:07:43 05/05/2010 08:07:43
648 05/05/2010 08:15:17 05/05/2010 08:15:16
650 05/05/2010 09:45:17 05/05/2010 09:45:17
651 05/05/2010 12:10:08 05/05/2010 12:10:07
652 06/05/2010 06:33:29 06/05/2010 06:33:29
653 06/05/2010 06:47:50 06/05/2010 06:47:49
656 06/05/2010 07:12:20 06/05/2010 07:12:20
654 06/05/2010 07:12:35 06/05/2010 07:12:35
655 06/05/2010 07:43:56 06/05/2010 07:43:55
657 06/05/2010 07:48:05 06/05/2010 07:48:05
661 06/05/2010 07:48:38 06/05/2010 07:48:37
658 06/05/2010 07:49:15 06/05/2010 07:49:15
659 06/05/2010 07:55:21 06/05/2010 07:55:20
660 06/05/2010 07:55:26 06/05/2010 07:55:25
663 06/05/2010 07:56:55 06/05/2010 07:56:54
662 06/05/2010 07:57:57 06/05/2010 07:57:56
664 06/05/2010 08:20:59 06/05/2010 08:20:59
665 06/05/2010 08:21:39 06/05/2010 08:21:38
666 06/05/2010 08:22:31 06/05/2010 08:22:30
667 07/05/2010 06:23:09 07/05/2010 06:23:09
668 07/05/2010 07:03:22 07/05/2010 07:03:22
671 07/05/2010 07:22:07 07/05/2010 07:22:07
669 07/05/2010 07:22:27 07/05/2010 07:22:26
670 07/05/2010 07:23:57 07/05/2010 07:23:57
676 07/05/2010 07:24:55 07/05/2010 07:24:54
672 07/05/2010 07:25:35 07/05/2010 07:25:34
673 07/05/2010 07:25:45 07/05/2010 07:25:44
674 07/05/2010 07:26:44 07/05/2010 07:26:43
675 07/05/2010 07:26:59 07/05/2010 07:26:59
677 07/05/2010 07:27:40 07/05/2010 07:27:39
678 07/05/2010 07:57:00 07/05/2010 07:56:59
679 07/05/2010 07:59:33 07/05/2010 07:59:32
680 10/05/2010 06:54:17 10/05/2010 06:54:17
682 10/05/2010 07:48:45 10/05/2010 07:48:44
683 10/05/2010 07:54:06 10/05/2010 07:54:06
684 10/05/2010 08:00:36 10/05/2010 08:00:35
685 10/05/2010 08:01:30 10/05/2010 08:01:29
687 10/05/2010 08:05:17 10/05/2010 08:05:17
691 10/05/2010 08:05:43 10/05/2010 08:05:42
688 10/05/2010 08:05:51 10/05/2010 08:05:50
689 10/05/2010 08:06:22 10/05/2010 08:06:21
692 10/05/2010 08:27:31 10/05/2010 08:27:30
693 10/05/2010 08:36:23 10/05/2010 08:36:22
696 11/05/2010 07:18:25 11/05/2010 07:18:24
697 11/05/2010 07:18:46 11/05/2010 07:18:45
700 11/05/2010 07:19:05 11/05/2010 07:19:04
701 11/05/2010 08:09:42 11/05/2010 08:09:41
702 11/05/2010 08:10:00 11/05/2010 08:09:59
703 11/05/2010 08:10:53 11/05/2010 08:10:52
704 11/05/2010 08:21:42 11/05/2010 08:21:42
705 11/05/2010 08:25:26 11/05/2010 08:25:26
707 11/05/2010 08:37:01 11/05/2010 08:37:01
710 11/05/2010 13:26:47 11/05/2010 13:26:47
711 12/05/2010 06:18:28 12/05/2010 06:18:28
712 12/05/2010 06:27:24 12/05/2010 06:27:24
715 12/05/2010 06:35:09 12/05/2010 06:35:09
716 12/05/2010 07:09:11 12/05/2010 07:09:10
717 12/05/2010 07:27:33 12/05/2010 07:27:32
718 12/05/2010 08:00:31 12/05/2010 08:00:30
719 12/05/2010 08:06:11 12/05/2010 08:06:11
720 12/05/2010 08:13:26 12/05/2010 08:13:25
722 12/05/2010 09:37:14 12/05/2010 09:37:14
723 12/05/2010 09:49:00 12/05/2010 09:49:00
724 12/05/2010 09:52:22 12/05/2010 09:52:22
725 13/05/2010 07:35:34 13/05/2010 07:35:33
726 13/05/2010 07:36:55 13/05/2010 07:36:55
727 13/05/2010 07:48:20 13/05/2010 07:48:20
728 13/05/2010 07:48:58 13/05/2010 07:48:58
729 13/05/2010 07:49:16 13/05/2010 07:49:15
730 13/05/2010 07:49:32 13/05/2010 07:49:31
731 13/05/2010 07:50:42 13/05/2010 07:50:41
732 13/05/2010 07:50:56 13/05/2010 07:50:56
733 13/05/2010 07:51:19 13/05/2010 07:51:18
734 13/05/2010 08:23:26 13/05/2010 08:23:26
735 13/05/2010 08:29:24 13/05/2010 08:29:23
736 13/05/2010 08:29:54 13/05/2010 08:29:54
737 13/05/2010 08:37:43 13/05/2010 08:37:42
740 14/05/2010 07:07:26 14/05/2010 07:07:25
739 14/05/2010 07:10:40 14/05/2010 07:10:39
742 14/05/2010 07:33:53 14/05/2010 07:33:53
741 14/05/2010 07:35:40 14/05/2010 07:35:40
743 14/05/2010 07:48:59 14/05/2010 07:48:59
745 14/05/2010 07:53:39 14/05/2010 07:53:38
747 14/05/2010 08:01:44 14/05/2010 08:01:44
748 14/05/2010 08:13:42 14/05/2010 08:13:42
749 14/05/2010 08:30:46 14/05/2010 08:30:45
750 14/05/2010 14:22:10 14/05/2010 14:22:10
751 14/05/2010 14:22:18 14/05/2010 14:22:17
752 14/05/2010 14:22:29 14/05/2010 14:22:28
753 14/05/2010 14:22:36 14/05/2010 14:22:36
754 17/05/2010 06:30:14 17/05/2010 06:30:14
755 17/05/2010 07:09:36 17/05/2010 07:09:35
756 17/05/2010 07:36:00 17/05/2010 07:35:59
757 17/05/2010 07:37:44 17/05/2010 07:37:44
758 17/05/2010 07:42:25 17/05/2010 07:42:25
759 17/05/2010 07:45:27 17/05/2010 07:45:26
762 17/05/2010 07:54:13 17/05/2010 07:54:13
760 17/05/2010 08:10:35 17/05/2010 08:10:34
761 17/05/2010 08:19:49 17/05/2010 08:19:48
763 17/05/2010 08:27:19 17/05/2010 08:27:19
764 17/05/2010 08:48:59 17/05/2010 08:48:59
765 17/05/2010 09:08:30 17/05/2010 09:08:30
766 17/05/2010 10:02:44 17/05/2010 10:02:44
767 17/05/2010 10:03:50 17/05/2010 10:03:50
769 17/05/2010 10:49:05 17/05/2010 10:49:04
771 18/05/2010 07:50:58 18/05/2010 07:50:57
772 18/05/2010 07:51:39 18/05/2010 07:51:39
773 18/05/2010 07:52:01 18/05/2010 07:52:01
779 18/05/2010 07:52:32 18/05/2010 07:52:32
775 18/05/2010 08:09:50 18/05/2010 08:09:50
776 18/05/2010 08:11:00 18/05/2010 08:11:00
777 18/05/2010 08:11:26 18/05/2010 08:11:26
778 18/05/2010 08:13:01 18/05/2010 08:13:01
780 18/05/2010 08:35:50 18/05/2010 08:35:50
781 18/05/2010 08:36:11 18/05/2010 08:36:11
782 18/05/2010 08:37:40 18/05/2010 08:37:39
783 18/05/2010 08:39:36 18/05/2010 08:39:36
784 18/05/2010 09:09:21 18/05/2010 09:09:21
790 19/05/2010 08:07:33 19/05/2010 08:07:33
789 19/05/2010 08:16:56 19/05/2010 08:16:55
791 19/05/2010 08:20:01 19/05/2010 08:20:00
792 19/05/2010 08:20:28 19/05/2010 08:20:28
793 19/05/2010 08:20:50 19/05/2010 08:20:50
794 19/05/2010 08:21:07 19/05/2010 08:21:06
796 19/05/2010 08:25:59 19/05/2010 08:25:58
798 19/05/2010 08:50:31 19/05/2010 08:50:31
799 19/05/2010 08:51:46 19/05/2010 08:51:45
800 19/05/2010 08:57:00 19/05/2010 08:57:00
801 19/05/2010 09:26:33 19/05/2010 09:26:33
803 19/05/2010 14:00:53 19/05/2010 14:00:52
804 20/05/2010 06:13:13 20/05/2010 06:13:12
805 20/05/2010 07:00:49 20/05/2010 07:00:48
806 20/05/2010 07:02:05 20/05/2010 07:02:05
807 20/05/2010 07:27:14 20/05/2010 07:27:14
808 20/05/2010 07:35:44 20/05/2010 07:35:43
809 20/05/2010 07:36:30 20/05/2010 07:36:29
810 20/05/2010 07:36:49 20/05/2010 07:36:48
814 20/05/2010 07:59:58 20/05/2010 07:59:57
815 20/05/2010 08:01:15 20/05/2010 08:01:14
816 20/05/2010 08:03:57 20/05/2010 08:03:56
817 20/05/2010 08:13:35 20/05/2010 08:13:34
818 20/05/2010 08:13:51 20/05/2010 08:13:50
819 21/05/2010 06:46:01 21/05/2010 06:46:01
820 21/05/2010 06:46:26 21/05/2010 06:46:25
821 21/05/2010 07:18:05 21/05/2010 07:18:04
822 21/05/2010 07:22:13 21/05/2010 07:22:13
823 21/05/2010 07:31:53 21/05/2010 07:31:52
824 21/05/2010 07:33:44 21/05/2010 07:33:44
825 21/05/2010 07:34:25 21/05/2010 07:34:25
826 21/05/2010 07:51:22 21/05/2010 07:51:21
827 21/05/2010 07:53:33 21/05/2010 07:53:33
828 21/05/2010 08:22:47 21/05/2010 08:22:47
829 21/05/2010 08:25:26 21/05/2010 08:25:25
830 21/05/2010 08:40:19 21/05/2010 08:40:19
831 21/05/2010 08:42:29 21/05/2010 08:42:28
832 21/05/2010 11:50:08 21/05/2010 11:50:07
847 24/05/2010 10:36:02 24/05/2010 10:36:02
848 24/05/2010 11:14:15 24/05/2010 11:14:15
849 24/05/2010 11:14:40 24/05/2010 11:14:39
850 24/05/2010 11:14:46 24/05/2010 11:14:45
851 24/05/2010 11:14:52 24/05/2010 11:14:52
853 24/05/2010 11:19:13 24/05/2010 11:19:13
855 24/05/2010 11:19:36 24/05/2010 11:19:36
856 24/05/2010 11:19:52 24/05/2010 11:19:52
857 24/05/2010 11:20:15 24/05/2010 11:20:15
859 24/05/2010 11:27:46 24/05/2010 11:27:46
868 24/05/2010 11:58:58 24/05/2010 11:58:58
873 25/05/2010 09:57:07 25/05/2010 09:57:06
876 25/05/2010 10:17:17 25/05/2010 10:17:16
878 25/05/2010 10:20:25 25/05/2010 10:20:24
879 25/05/2010 10:27:39 25/05/2010 10:27:39
901 25/05/2010 12:37:12 25/05/2010 12:37:12
903 25/05/2010 12:39:13 25/05/2010 12:39:12
915 25/05/2010 16:04:45 25/05/2010 16:04:44
923 25/05/2010 16:13:25 25/05/2010 16:13:24
926 25/05/2010 16:14:00 25/05/2010 16:13:59
927 25/05/2010 16:14:05 25/05/2010 16:14:05
1543 05/07/2010 14:57:03 05/07/2010 14:52:40
-----Mensagem original-----
De: [email protected]
[mailto:[email protected]] Em nome de Leonardo
Cezar
Enviada em: quinta-feira, 6 de janeiro de 2011 16:59
Para: TI
Cc: Comunidade PostgreSQL Brasileira
Assunto: Re: [pgbr-geral] Coluna DataType Timestamp : Comparativo equivocado
ou abordagem equivocada?
2011/1/6 TI <[email protected]>:
> Ai é que está o caso...
>
> Supondo que sim (já suspeitava), mas no contexto geral quando fazemos a
> chamada via query estamos por default chamando no formato (dd/mm/yyyy
> hh:mm:ss), neste caso os microsegundos não deveria ser desprezados?
Não sei.
Estou bastante curioso para ver uma amostragem real da coluna
timestamp do seu banco e a consulta que está disparando nestes dados.
Sem essas informações ficaremos especulando...
-Leo
--
Leonardo Cezar
http://postgreslogia.wordpress.com
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
