B4J Question Where i wrong ?

[moore_it]

Hi all,

i use this format for time :

datetime.dateformat = "HHmmss"

to write in database table
When i read the info from db table i use this format for time:

datetime.dateformat = "HHmmss"
datetime.timeparse("datefield in format HHmmss")

if hour is smaller than 10 the program crash where i wrong ?

 

[Star-Dust]

Hi all,

i use this format for time :

datetime.dateformat = "HHmmss"

to write in database table
When i read the info from db table i use this format for time:

datetime.dateformat = "HHmmss"
datetime.timeparse("datefield in format HHmmss")

if hour is smaller than 10 the program crash where i wrong ?

Do I always sign the hours with 2 digits? (type 03)

 

[moore_it]

why the dateparse not have the same problem ?

 

[Jmu5667]

how have you define the datefield in your database? Your problem is mostliky that hours less then 10 may loose the leading zero.

 

[moore_it]

Ok the date not have the problem if in format yyyyMMdd

Thanks

 

[moore_it]

How i do for define correctly the time field in database ?

 

[Jmu5667]

What database are you using ?

 

[moore_it]

sqlite

 

[moore_it]

but if i write in format ssmmHH work like yyyyMMdd right ?

 

[moore_it]

No it is the same with seconds ...

 

[Jmu5667]

you could just store the date as a long value

 

[moore_it]

Yes good idea thanks very much Jmu5667!

 

[Jmu5667]

Your welcome