DateTimeValid (Function) Checks the validity of a date/time between January 01, 0001 at 0 hours 0 minutes 0 seconds 0 hundredths of a second and December 31, 9999 at 23 hours 59 minutes 59 seconds 99 hundredths of a second.... Year (Property) The Year property is used to: Get the year from a Date or DateTime variable or item. Change the year in a Date or DateTime variable or item.... <DateTime type>.ToString (Function) Converts a DateTime to string in the specified format. DateTimeToString (Function) Converts a DateTime to string in the specified format. Date (Property) The Date property is used to: Retrieve the date from a DateTime variable. Modify the date in a DateTime variable. Retrieve the date from a Date item (in "Date and Time" format) . Modify the date in a Date item (in "Date and Time" format)... Time (Property) The Time property enables you to: Retrieve the time from a DateTime variable. Modify the time in a DateTime variable. Retrieve the time from in a Date item (in "Date and Time" format) Modify the time in a Date item ("Date and Time" format).... DateTime (Type of variable) The DateTime type enables you to easily handle a date and a time... DateTimeByDefault (Function) Used to define the default value of Date, Time and DateTime variables. Month (Property) The Month property is used to: Retrieve the month from a Date or DateTime variable. Modify the month in a Date or DateTime variable. Retrieve the month from a Date item (in "Simple date" or "Date and Time" format) Modify the month in a Date item (in "Simple Date" or "Date and Time" format)... Managing dates and times WINDEV, WEBDEV and WINDEV Mobile propose several methods for managing dates and times in your applications...... Second (Property) The Second property is used to: Retrieve the number of seconds from a Time, DateTime or Duration variable. Modify the number of seconds in a Time, DateTime or Duration variable. Retrieve the seconds or the number of seconds from a Date item (in "Date and Time" or "Duration" format) Modify the seconds or the number of seconds in a Date item (in "Date and Time" or "Duration" format)... Millisecond (Property) The Millisecond property is used to: Retrieve the number of milliseconds from a Time, DateTime or Duration variable. Modify the number of milliseconds in a Time, DateTime or Duration variable. Retrieve the milliseconds or the number of milliseconds from a Date item (in "Date and Time" or "Duration" format) Modify the milliseconds or number of milliseconds in a Date item ("Date and Time" or "Duration" format)... Minute (Property) The Minute property is used to: Retrieve the minutes from a Time or DateTime variable, or the number of minutes from a Duration. Change the minutes in a Time or DateTime variable, or the number of minutes in a Duration. Retrieve the minutes or the number of minutes from a Date item (in "Date and Time" or "Duration" format) or from a Time item. Modify the minutes or the number of minutes in a Date item (in "Date and Time" or "Duration" format) or in a Time item.... <DateTime type>.ToEpoch (Function) Converts a local datetime to Epoch format (number of time units since 01/01/1970 at 00h00 UTC).... DateTimeToEpoch (Function) Converts a local datetime to Epoch format (number of time units since 01/01/1970 at 00h00 UTC).... Day (Property) The Day property is used to: Get the day from a Date or DateTime variable, or get the number of days from a Duration variable. Change the day of a Date or DateTime variable, or change the number of days of a Duration variable. Get the day or the number of days from a Date item (in "Date", "Date and Time" or "Duration" format) Modify the day or the number of days in a Date item (in "Date", "Date and Time" or "Duration" format)... EpochToDateTime (Function) Converts a date and a time in Epoch format (number of time units since 01/01/1970 at 00h00 UTC) to a local datetime.... Hour (Property) The Hour property is used to: Get the time from a variable of type Time or DateTime, or the number of hours from a variable of type Duration. Change the time in a variable of type Time or DateTime, or the number of hours in a variable of type Duration. Retrieve the time or the number of hours from a Date item (in "Date and time" or "Duration" format) or from a Time item. Modify the time or the number of hours in a Date item (in "Date and time" or "Duration" format) or in a Time item.... Operations available for the dates, times and durations, ... The following operations are available for the following types of variables...... External language: Programming in COBOL We are going to call the elements developed in WINDEV (project, windows, analysis, ...... TimestampType (Property) The TimestampType property is used to: Find out the type of timestamp for an item. This item was defined in the data model editor or through programming. Define the type of timestamp for a Date, Time or DateTime item (when describing the item through programming).... External language: Programming in Java We are going to call the elements developed in WINDEV (project, windows, analysis, ...... Overview of external languages Variant (Type of variable) The Variant type is used to: store any simple value: boolean, numeric (Currency, Real, Integer, etc.), characters and character string, date (Date, Time, DateTime and Duration), ... store named or indexed subelements. store any complex value: structures, classes, advanced types, arrays, associative arrays, queues, stacks and lists. handle the NULL value in WLanguage. store interactions with ActiveX objects and Automation programming.... <Source>.ExecuteSQLQuery (Function) Initializes a query written in SQL language and declares this query to the HFSQL engine.