<ADODB_Recordset>.CollectD

<< Click to Display Table of Contents >>

Navigation:  ThinBASIC Modules > ADODB > ADODB Module Classes > ADODB_Recordset > ADODB_Recordset Properties >

<ADODB_Recordset>.CollectD

 

Description

 
Returns or set the value of a Field object in the form of a date.

Date format is the following "YYYY-MM-DD HH:MM:SS"

 

Syntax

 

GET

s = <ADODB_Recordset>.CollectD(FieldName [, ShowTime])

 

SET

<ADODB_Recordset>.CollectD(Name) = String (format to be used "YYYY-MM-DD HH:MM:SS")

 

Returns

 

String in the format of "YYYY-MM-DD HH:MM:SS"

 

Parameters

 

Name

Type

Optional

Meaning

FieldName

String

No

Field Name (the name of the column in the RecordSet)

ShowTime

Number

Yes

If %TRUE and FieldName is a DateTime field, returned string will contain time information, otherwise only the date

 

Remarks

 

Restrictions

 

See also

 

Examples