How to get current Date and Time from Sql Server

[Moises Bagsit]

Good day. I'm using SQL Server and Springboot for my web api.

Database Property:

table="UserAccount"
row="CreatedDate"
datatype="DateTime"

Springboot Model:

public class UserAccount {
@CreationTimestamp
@Column(name = "CreatedDate", columnDefinition = "datetime", nullable = false)
private Date createdDate;
}

Sample Data:

{ 
"userId":1,
"username":"1",
"password":"1",
"createdDate":"2020-01-21T07:17:34.963+0000",
"createdById":1,
"revisedDate":null,
"revisedById":null,
"cancelledDate":null,
"cancelledById":null
}

Is there a way to get the current date and time from the main server when posting new data in springboot? As of now, @CreationTimestamp use the client pc's current datetime (which we can assume that the varies from desktop to desktop). It's working but the date should be from the server to maintain consistency.

Thanks.

[Stephan van Hulst]

Welcome to CodeRanch!

Moises Bagsit wrote:As of now, @CreationTimestamp use the client pc's current datetime (which we can assume that the varies from desktop to desktop).

How do you figure? How would Hibernate have access to the client system?

[Christopher Schneider]

The date would only come from the client if the date is supplied by the client via a request. Otherwise, it's coming from the server.