Callque.activatetime Column Question

[Guest ooper]

I notice that the ActivateTime column in the CallQue table is of type Number. If I am inserting data directly into the table using the Database Query module, what should the insert query look like? Can you give me an example? Can you point me somewhere that enumerates the options/formats? I guess I'm wondering if a Number data type can accept various date/time formats?

 

Thanks,

Brian Barnett

[SupportTeam]

Just make a few inserts using the Telephone Number Loader and then you can open the database and see the formats used.

[Guest ooper]

I have seen the format, but I'm not sure how the date is being represented. I assume the last 4 digits of the number is the time component in 24 hour format, but I'm not sure about 5 digit date component of the number. Can you shed some light on that for me?

[SupportTeam]

That would most likely be YMMDD format, with Y being the last digit of the current year.