You are not logged in.

axtens

Trainee

  • "axtens" is male
  • "axtens" started this thread

Posts: 37

Date of registration: Mar 16th 2009

Location: Perth, WA, Australia

Occupation: Software/Test Engineer

Hobbies: be a husband and a dad, play ukulele, sing

  • Send private message

1

Thursday, October 22nd 2009, 4:04am

Hour() of meridian-free date/time gives 'wrong' answer

Jabaco Source

 
1
2
3

Dim d As Date 
   d = CDate("22/2/2009 12:00:00")
   msgbox hour(d)


There is no AM/PM, and Jabaco returns zero. However, VBScript (and I expect VB as well) returns 12.

Kind regards,
Bruce.

A1880

Intermediate

  • "A1880" is male

Posts: 500

Date of registration: Jan 1st 2009

Location: Hanover, Germany

Occupation: Software Engineer

Hobbies: Hilbert Curves

  • Send private message

2

Thursday, October 22nd 2009, 9:37am

Yes, this looks like a bug in framework function Conversion.CDate().

I tried the following:

Jabaco Source

 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15

Public Sub Command1_Click()
    Dim sFormat As String   = "dd/mm/yyyy HH:MM:ss"
    Dim sdFormat As java#text#SimpleDateFormat = New SimpleDateFormat(sFormat)
    Dim InputDate As String = "22/02/2009 12:01:00"
    Dim d As Date           = sdFormat.parse(InputDate)
    Dim s1 As String
    Dim s2 As String 
      
    s1 = sdFormat.format(d) & " hour=" & Hour(d) & " day=" & Day(d) & " month=" & Month(d) & " year=" & Year(d)

    d = CDate(InputDate)
    s2 = sdFormat.format(d) & " hour=" & Hour(d) & " day=" & Day(d) & " month=" & Month(d) & " year=" & Year(d)
    
    MsgBox s1 & vbCrLf & s2
End Sub


Java SimpleFormat() does the job. But Month() returns "1" rather than "2" in both cases.

Greetings

A1880

OlimilO

Intermediate

  • "OlimilO" is male

Posts: 277

Date of registration: Jan 18th 2009

Location: Germany

Occupation: software engineer

  • Send private message

3

Thursday, October 22nd 2009, 10:56am

Month

Hi,

what the hell... I'm going to go on the warpath with java date.

I thought I've already fixed this?

http://code.google.com/p/jabacoframework…A/DateTime.java


it would really be good to have some more helpers on the Jabaco Framework



OlimilO

A1880

Intermediate

  • "A1880" is male

Posts: 500

Date of registration: Jan 1st 2009

Location: Hanover, Germany

Occupation: Software Engineer

Hobbies: Hilbert Curves

  • Send private message

4

Thursday, October 22nd 2009, 11:09am

I noticed that Conversion.CDate() always assumes the presence of an AM/PM in the input format.
Might be that the default behaves differently from what one would expect.

java.text.SimpleDateFormat() has a format qualifier "a" which stands for the AM/PM marker.
This "a" is present in all formats tried by Conversion.CDate().

VB6 Month() returns months between 1 and 12 (cf. http://msdn.microsoft.com/en-us/library/s70thwaz(VS.80).aspx).
This is different from the java style. Calendar.get(Calendar.MONTH) returns 0 .. 11.

Cheers!

A1880

Similar threads

Rate this thread
WoltLab Burning Board