SQL.GetFieldAsDateTime
----------------------

Returns field's value as timestamp value.-

| Component | Version | macOS | Windows | Linux | Server | iOS SDK |
|---|---|---|---|---|---|---|
| [SQL](component_SQL.md) | [2.6](newinversion26.md) | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes | ✅ Yes |

MBS( "SQL.GetFieldAsDateTime"; Command; Field ) 

**MBS**( **"SQL.GetFieldAsDateTime";** /\* Returns field's value as timestamp value.- \*/  
**$Command**; /\* The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). \*/   
**$Field**) /\* The name or one based index of the field. \*/ 

(old name: SQL.GetFieldAsTimestamp)

### Parameters

| Parameter | Description | Example |
|---|---|---|
| Command | The command reference number gained with [SQL.NewCommand](SQLNewCommand.md). | $Command |
| Field | The name or one based index of the field. | $Field |

### Result

Returns date and time value or error message.

### Description

Returns field's value as timestamp value.-  
Converts if needed.  
  
see also:  
[https://www.sqlapi.com/ApiDoc/class\_s\_a\_field.html](https://www.sqlapi.com/ApiDoc/class_s_a_field.html)  
### Examples

Read null value as empty, otherwise get timestamp:

 If(  
 MBS ("[SQL.GetFieldIsNull](SQLGetFieldIsNull.md)"; $command ; "FieldName");   
 "";  
 MBS ("SQL.GetFieldAsDateTime"; $command ; "FieldName"))  
### See also

- [SQL.ConvertDateTimeFromSQL](SQLConvertDateTimeFromSQL.md)
- [SQL.GetFieldAsDate](SQLGetFieldAsDate.md)
- [SQL.GetFieldAsTime](SQLGetFieldAsTime.md)
- [SQL.GetFieldDataType](SQLGetFieldDataType.md)
- [SQL.GetFieldIsNull](SQLGetFieldIsNull.md)
- [SQL.GetParamAsDateTime](SQLGetParamAsDateTime.md)
- [SQL.NewCommand](SQLNewCommand.md)
- [SQL.SetParamAsDateTime](SQLSetParamAsDateTime.md)

This function is free to use.

Created 18th August 2014 , last changed 25th February 2021

  
[SQL.GetFieldAsDate](SQLGetFieldAsDate.md) - [SQL.GetFieldAsFloat](SQLGetFieldAsFloat.md)

[HTML Version](SQLGetFieldAsDateTime.shtml)