SQLQuery and time stamp

[qwerty]

I tried retrieving a time stamp like this

Code: [Select]

my $v = $rep->SQLQuery("SELECT ModifiedDate FROM t_diagram");
print $v;
but EA returned only the date and not the time. But ModifiedDate is a time stamp as you can see when running the query in the SQL pad.

Bug reported.

q.

[Geert Bellekens]

qwerty,

Just a wild guess, but have you tried

Code: [Select]

my $v = $rep->SQLQuery("SELECT ModifiedDate AS myValue FROM t_diagram");
print $v;We know EA sometimes does funny stuff with the resultsets depending on the alias. I wouldn't be surprised if they somehow cast dates depending on the name of the column.

Geert

[qwerty]

Yes. I tried that and it did not work either.

q.

[Geert Bellekens]

Hmm, too bad.

Maybe if you explicitly cast it to a string in a certain format (including time)?

Geert

[qwerty]

No. The return value is already a (XML) string. And that does not contain the time part. Just the date.

q.

[Geert Bellekens]

Yes, but in your query I mean.
In most SQL dialects there are functions to format dates.
In that case the format would be applied before it would be serialized in an xml.

Geert

[qwerty]

Actually I'm doing this investigation on behalf of someone else on SO. Will have a look if Access has something to offer.

q.

  That did the trick:

Code: [Select]

my $dia = $rep->SQLQuery("SELECT Format (ModifiedDate, \"Short Time\") AS T FROM t_diagram");
print $dia;