1. Forum
  2. Usenet
  3. COMP.DATABASES.INGRES

  • Ingresdate and Help Table

    From Steve@21:1/5 to All on Wed Apr 14 20:47:05 2021
    Hi folks

    How were date columns displayed by the help table statement prior to Ingres 11?

    In my Ingres installation data_alias is set to ingresdate.

    For example, for the following table definition:

    create table steves_tmp (
    col1 date not null with default);

    In Ingres 11, help table steves_tmp displays the type of col1 as ingresdate.

    I am curious to know if this was the case prior to Ingres 11? Or did help table display the type simply as date?

    Thanks
    Steve

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Roy Hann@21:1/5 to Steve on Mon Apr 19 08:43:01 2021
    Steve wrote:

    How were date columns displayed by the help table statement prior to Ingres 11?

    [snip]

    I am curious to know if this was the case prior to Ingres 11? Or did help table display the type simply as date?

    I've just refreshed my memory using a 10.1 installation. As I thought,
    it shows the date as ingresdate.

    Roy

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Steve@21:1/5 to Roy Hann on Sun Jun 13 08:01:29 2021
    Roy Hann wrote:
    I've just refreshed my memory using a 10.1 installation. As I thought,
    it shows the date as ingresdate.

    Thanks Roy, makes sense. I presume it must have changed when Ansidate was first included in Ingres 9.1.

    The question arose because a script I use to migrate database changes between environments started failing. The script wasn't recognising the data type Ingresdate.

    Steve

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)