We are looking to automate the updating of mailing list subscribers by inserting them in the SQLite db using a powershell script. Inserting them isn't a big deal, but what I am confused by are the some fields in the Subscribers and MailingListSubscribers tables. There are CreatedOn and EditedOn and BounceAddress in Subscribers, and SubscribedOn in MailingListSubscribers. The date fields are a timestamp of some sort, but they are not Epoch Time.
My question: are these fields required and if so what is the format I should be using?
TIA - Greg