Skip to content
Snippets Groups Projects
Select Git revision
  • benchmark-tools
  • postgres-lambda
  • master default
  • REL9_4_25
  • REL9_5_20
  • REL9_6_16
  • REL_10_11
  • REL_11_6
  • REL_12_1
  • REL_12_0
  • REL_12_RC1
  • REL_12_BETA4
  • REL9_4_24
  • REL9_5_19
  • REL9_6_15
  • REL_10_10
  • REL_11_5
  • REL_12_BETA3
  • REL9_4_23
  • REL9_5_18
  • REL9_6_14
  • REL_10_9
  • REL_11_4
23 results

sysfunc.c

  • Marc G. Fournier's avatar
    427a964c
    |From: Keith Parks <emkxp01@mtcc.demon.co.uk> · 427a964c
    Marc G. Fournier authored
    |Subject: [PATCH] adding SYS_TIME just for fun.
    |
    |Hi,
    |
    |Whilst I was playing round with the European dates patch I noticed the sysfunc()
    |that allows you to do :-
    |
    |create table test ( da date);
    |insert into test values (SYS_DATE);
    |
    |and have the current system date inserted.
    |
    |So I thought it would be nice to have the SYS_TIME facility too.
    |
    |I've cloned the function and changed a few things and there you have it,
    |you can now do:
    |
    |create table test2 ( ti time);
    |insert into test2 values (SYS_TIME);
    427a964c
    History
    |From: Keith Parks <emkxp01@mtcc.demon.co.uk>
    Marc G. Fournier authored
    |Subject: [PATCH] adding SYS_TIME just for fun.
    |
    |Hi,
    |
    |Whilst I was playing round with the European dates patch I noticed the sysfunc()
    |that allows you to do :-
    |
    |create table test ( da date);
    |insert into test values (SYS_DATE);
    |
    |and have the current system date inserted.
    |
    |So I thought it would be nice to have the SYS_TIME facility too.
    |
    |I've cloned the function and changed a few things and there you have it,
    |you can now do:
    |
    |create table test2 ( ti time);
    |insert into test2 values (SYS_TIME);