Convert spinner.dateValue to a sql timestamp

Ignition
6

  1. Are you sure this returns a time stamp databasePruningConfiguration.getExecutionTime(), you can show the code

  2. Is it supposed to? The Value(Date) property of the spinner is a Date object, not a timestamp, but timestamp is a subclass of java.util.Date, so after that I guess you must use the timestamp

  3. As long as what you are trying to convert to a java.sql.Timestamp is a java.util.Date or similar you can try to fit what I have here below as an example of converting to java.sql.Timestamp

import java.sql.Timestamp

d = system.date.now()
toMS = system.date.toMillis(d)
ts = java.sql.Timestamp(toMS)
print ts
3 Likes