datetime

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...

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"...

(Here for iOS version) SD_DiscTimePicker Author: Star-Dust Version: 0.03 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.