Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2007
    Posts
    61

    Unanswered: Recording DateTime and showing it

    Hello.

    I'm trying to record in one table:
    create table t
    (
    dat_anydate date
    )

    insert into t (current);

    So, when I use select * from t, I get:

    dat_anydate
    '11/10/2008'

    I would like to catch '11/10/2008 12:30'

    Is it possible ?

    Thanks.
    Fernando.

  2. #2
    Join Date
    Nov 2008
    Posts
    65
    Provided Answers: 1
    In Informix date is just date (as you can read: date).
    If you want to use more granulated time, you can use:
    datetime year to minute
    and then you can store "mm/dd/yyyy hh:mm"
    HTH

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •