datetime

Hey everyone! Background: I recently moved to Queensland (Australia) which doesn't have daylight savings like the southern states (where I'm from) do. Consequently, during summer the sun comes up at the ungodly hour of 4:45am or thereabouts. It got me thinking, would it be possible to design...

I run a request to a web server with the Maria SQL database, in the response I get a field with a date in the TIMESTAMP(6) format. I want to store the value of this field into a variable. But at me it turns out to save only in a string. Then it is not convenient for me to process it. How can I...

Hi everyone, there is a way to show this native-looking dialog to choose a time with B4A? From: https://androidexample365.com/material-time-picker-for-developer/ Or something like: Thanks in advance!

Hello, Would like to know how DateTime.Now arrives the value in B4A and B4J. Does it takes the value from computer? Does it requires any internet connection to fetch value from somewhere? Changing the computer system's Date and Time, In B4A, it returns the correct value. Then...

Hi all and happy 2021. I'm run into the problem (yes, I know, my fault). The problem is that I saved date into my table like this 05/05/2020. For the whole year it was OK but this morning I realized that I did it wrong. When I run a query like this select * from mytable where jobdate between...

On a B4Xpage we have two DatePicker field txtFromDate and txtToDate How to set these field from code, having a date like a string value? txtFromDate.DateTicks = ??? Wich function that return a DateTicks from a string (example "14/09/2020") ?

DateTime.DateFormat="YYYY-MM-dd" Log (DateTime.DateParse( "2020-08-16")) Log (DateTime.DateParse( "2020-08-21")) The Log says : 2020-08-16 = 1577660400000 2020-08-21 = 1577660400000 both results are the same... ?

can certainly still be optimized. Private Sub isCurrentMonth(ticks As Long) As Boolean Return DateTime.GetYear(ticks) = DateTime.GetYear(DateTime.Now) And DateTime.GetMonth(ticks) = DateTime.GetMonth(DateTime.Now) End Sub Private Sub isSameYear(ticks_1 As Long,ticks_2 As Long) As...

DateTimePicker view is based on the CustomListView and snapCLV with a design similar to the ios datetime picker. This view has only been tested in B4A, it is not very useful in B4i since for ios the built-in picker is better. 1. Add the module and layout to your project (attached...

Sub convert_seconds2Ticks(seconds As Long) As Long seconds = seconds * DateTime.TicksPerSecond 'convert seconds to ticks! Return seconds End Sub

I'm trying to convert a 24 hour time to 12 hour with AM/PM. I've tried to use the documentation for date/time formats. Here's my code: Dim TimeString as String = "21:00" DateTime.DateFormat="HH:mm" Dim TimeValue=DateTime.TimeParse(TimeString&":00") as Long DateTime.DateFormat= "h:mm a"...

For Android and iOS. SD_DiscTimePicker Author: Star-Dust Version: 0.07 DiscTimePicker Events: Change (DateTimeChange As Long) Functions: Class_Globals As String DesignerCreateView (Base As Object, Lbl As Label, Props As Map) As String Base type must be Object Initialize (Callback As...

Hello guys, I know this been discussed here quite a few times, but I still am unable to format an SQL date field as I desire, it keeps showing me the date as yyyy-mm-dd... I tried the following code and the result is always the same: yyyy-mm-dd DateTime.DateFormat = "dd/MM/yyyy" wDataEvento...

DDL code: [entrCreate] INT NOT NULL DEFAULT (strftime('%s','now') *1000) Make sure that the expression (strftime('%s','now') *1000) is enclosed in brackets.