Comment by ncruces

Comment by ncruces a day ago

0 replies

Try one of these:

  strftime('%Y-%m-%dT%H:%M:%SZ')
  strftime('%Y-%m-%dT%H:%M:%fZ')
You can use this to convert whatever internal format you're using for presentation, in a SELECT statement. Like so (be sure to read up on 'auto', to see if it fits):

  strftime('%Y-%m-%dT%H:%M:%fZ', column, 'auto')