Results 1 to 2 of 2

Thread: DATE_VAL in the table BATCH_JOB_PARAMS

  1. Apr 29th, 2008, 08:06 AM #1
    springforever
    springforever is offline Member
    Join Date
    Mar 2008
    Posts
    60

    Lightbulb DATE_VAL in the table BATCH_JOB_PARAMS

    In the table BATCH_JOB_PARAMS, DATE_VAL column is getting the default value of "31-DEC-69 06.00.00.000000 PM".

    What do i need to configure to disable this?
    Reply With Quote Reply With Quote
  2. Apr 29th, 2008, 09:25 AM #2
    lucasward
    lucasward is offline Senior Member
    Join Date
    Dec 2006
    Posts
    1,061

    Default

    I'm assuming for your database value that's just the beginning of the epoch. I doubt there's any way to get rid of that. What I mean to say is, if the datatype was an int, it would be 0. In the case of a database, a timestamp value (which is used) has a '0' value of Dec 31 1969. (Usually it's jan 1 1970, but there's probably a quirk with your database)
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules