Author Topic: Automatic Timestamp as key field  (Read 3295 times)

PasiPK

  • Guest
Automatic Timestamp as key field
« on: September 24, 2009, 03:43:30 AM »
Hello,
would it be possible to have Default Value current timestamp like a Default Value for current date?
I mean in Application/Load Information if there is a date field, you can put Default Value t to get current date.
We have an application which can have multiple loads with same key fields during a day.
Timestamp would be a nice way to differentiate between loads and versions of this data.

Bill Dennis

  • Guest
Re: Automatic Timestamp as key field
« Reply #1 on: October 01, 2009, 11:04:07 AM »
I can't test this right now, but if you create an Application field for TIME and set the format like %H:%M and assign the Default value 't', OD might insert the time of day rather than date.

PasiPK

  • Guest
Re: Automatic Timestamp as key field
« Reply #2 on: October 05, 2009, 12:10:53 AM »
Thanks Bill! That worked. I tried also field with type DATE/TIME and that was fine too.