Date instead of timestamp in dbappender
Is there a way in dbappender, that timestamp field in logging_event will be a real date instead of int? -- View this message in context: http://old.nabble.com/Date-instead-of-timestamp-in-dbappender-tp32774133p327... Sent from the Logback User mailing list archive at Nabble.com.
On 3 November 2011 16:20, Jordan Blay <be.special@gmail.com> wrote:
Is there a way in dbappender, that timestamp field in logging_event will be a real date instead of int?
No. Different databases support different forms of a time stamp with different granularity, so the only reliably portable way to do it is with an int; you'll need to use a database specific function to turn in to you database specific timestamp - e.g. FROM_UNIXTIME on MySQL (from memory - please check!). Greg
On Thu, Nov 3, 2011 at 17:20, Jordan Blay <be.special@gmail.com> wrote:
Is there a way in dbappender, that timestamp field in logging_event will be a real date instead of int?
I added another column of type timestamp and a default value of 'CURRENT_TIMESTAMP'. This adds the current timestamp to each row that is inserted.
participants (3)
-
Greg Thomas -
Jordan Blay -
Stephan Vollmer