Bug: for datetime type field, at times getting an error during serialization

[rajasekarshanmugam]

Describe the bug

an object with below fields save as expected, but on deserialization fails with an error:

public DateTime? StartTimeUtc { get; set; }
public DateTime? EndTimeUtc { get; set; }

error throw is: 'Unable to parse DateTimeOffset from 2023-04-07T15:47:59.1047040'

Steps to reproduce

have a nullable date time field on an object and save. At times during deserialization we get the error as described. when using the below code we get an error:

var result = await _db.Select(Thing.From(id), cancellationToken);

'Unable to parse DateTimeOffset from 2023-04-07T15:47:59.1047040'

Expected behaviour

serialize and deserialize with datetime and datetimeoffset work as expected

Surreal.NET driver version

1.0.8

SurrealDB version

1.0.0-beta.9+20230402.5eafebd for linux on x86_64

Is there an existing issue for this?

• I have searched the existing issues