1. Forum
  2. USENET
  3. comp.databases.ingres

  • Ingresdate and Help Table

    From Steve@s.anderson.au@gmail.com to comp.databases.ingres on Wed Apr 14 20:47:05 2021
    From Newsgroup: comp.databases.ingres

    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
    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Roy Hann@specially@processed.almost.meat to comp.databases.ingres on Mon Apr 19 08:43:01 2021
    From Newsgroup: comp.databases.ingres

    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

    --- Synchronet 3.21b-Linux NewsLink 1.2
  • From Steve@s.anderson.au@gmail.com to comp.databases.ingres on Sun Jun 13 08:01:29 2021
    From Newsgroup: comp.databases.ingres

    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
    --- Synchronet 3.21b-Linux NewsLink 1.2