Difference between revisions of "Date.SQLDateTime"

From Xojo Documentation

m (Text replacement - "{{Deprecated" to "{{DeprecatedItem")
 
Line 1: Line 1:
{{Deprecated|version=2019r2|replacement=[[DateTime.SQLDateTime]]}}
+
{{DeprecatedItem|version=2019r2|replacement=[[DateTime.SQLDateTime]]}}
 
{{PropertyBox
 
{{PropertyBox
 
| name=SQLDateTime
 
| name=SQLDateTime

Latest revision as of 19:05, 3 September 2020

Read-Only Property (As String )
StringValue = aDate.SQLDateTime

Supported for all project types and targets.

Gets and sets the date in SQL date/time format, YYYY-MM-DD HH:MM:SS. Passing a bad string will result in an UnsupportedFormatException.

Notes

This is an example of an SQL date/time: 2008-09-03 13:39:16

Sample Code

The following code displays the current SQL date/time.

Var d As Date = Date.Now
Label1.Value = d.SQLDateTime