FormatDateTime - how to display nanoseconds?
up vote
0
down vote
favorite
I'm trying to display DB2 Timestamp which is of the form:
2007-09-24-15.53.37.2162474.
FormatDateTime() allows only displaying milliseconds.
How can I display full Timestamp string as defined in DB2?
My code looks like that now:
StringGrid1.Cells[i, query.RecNo] := FormatDateTime('yyyy-mm-dd.hh.mm.ss.zzz',
query.Fields[i].AsDateTime);
lazarus freepascal
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
asked Nov 10 at 11:07
Tadeusz R
61
add a comment |
up vote
0
down vote
favorite
I'm trying to display DB2 Timestamp which is of the form:
2007-09-24-15.53.37.2162474.
FormatDateTime() allows only displaying milliseconds.
How can I display full Timestamp string as defined in DB2?
My code looks like that now:
StringGrid1.Cells[i, query.RecNo] := FormatDateTime('yyyy-mm-dd.hh.mm.ss.zzz',
query.Fields[i].AsDateTime);
lazarus freepascal
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
asked Nov 10 at 11:07
Tadeusz R
61
add a comment |
up vote
0
down vote
favorite
up vote
0
down vote
favorite
I'm trying to display DB2 Timestamp which is of the form:
2007-09-24-15.53.37.2162474.
FormatDateTime() allows only displaying milliseconds.
How can I display full Timestamp string as defined in DB2?
My code looks like that now:
StringGrid1.Cells[i, query.RecNo] := FormatDateTime('yyyy-mm-dd.hh.mm.ss.zzz',
query.Fields[i].AsDateTime);
lazarus freepascal
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
asked Nov 10 at 11:07
Tadeusz R
61
I'm trying to display DB2 Timestamp which is of the form:
2007-09-24-15.53.37.2162474.
FormatDateTime() allows only displaying milliseconds.
How can I display full Timestamp string as defined in DB2?
My code looks like that now:
StringGrid1.Cells[i, query.RecNo] := FormatDateTime('yyyy-mm-dd.hh.mm.ss.zzz',
query.Fields[i].AsDateTime);
lazarus freepascal
lazarus freepascal
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
asked Nov 10 at 11:07
Tadeusz R
61
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
asked Nov 10 at 11:07
Tadeusz R
61
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
edited Nov 10 at 11:10
Tân Nguyễn
3,05832150
3,05832150
asked Nov 10 at 11:07
Tadeusz R
61
asked Nov 10 at 11:07
Tadeusz R
61
asked Nov 10 at 11:07
Tadeusz R
61
61
add a comment |
add a comment |
1 Answer
1
active
oldest
votes
up vote
-1
down vote
Ohhh! I was focused on the code instead of SQL.
Just used:
SELECT char(TIMESTAMP) FROM table;
and then:
StringGrid1.Cells[i, query.RecNo] := query.Fields[i].AsString;
answered Nov 10 at 11:45
Tadeusz R
61
add a comment |
1 Answer
1
active
oldest
votes
1 Answer
1
active
oldest
votes
active
oldest
votes
active
oldest
votes
up vote
-1
down vote
Ohhh! I was focused on the code instead of SQL.
Just used:
SELECT char(TIMESTAMP) FROM table;
and then:
StringGrid1.Cells[i, query.RecNo] := query.Fields[i].AsString;
answered Nov 10 at 11:45
Tadeusz R
61
add a comment |
up vote
-1
down vote
Ohhh! I was focused on the code instead of SQL.
Just used:
SELECT char(TIMESTAMP) FROM table;
and then:
StringGrid1.Cells[i, query.RecNo] := query.Fields[i].AsString;
answered Nov 10 at 11:45
Tadeusz R
61
add a comment |
up vote
-1
down vote
up vote
-1
down vote
Ohhh! I was focused on the code instead of SQL.
Just used:
SELECT char(TIMESTAMP) FROM table;
and then:
StringGrid1.Cells[i, query.RecNo] := query.Fields[i].AsString;
answered Nov 10 at 11:45
Tadeusz R
61
Ohhh! I was focused on the code instead of SQL.
Just used:
SELECT char(TIMESTAMP) FROM table;
and then:
StringGrid1.Cells[i, query.RecNo] := query.Fields[i].AsString;
answered Nov 10 at 11:45
Tadeusz R
61
answered Nov 10 at 11:45
Tadeusz R
61
answered Nov 10 at 11:45
Tadeusz R
61
answered Nov 10 at 11:45
Tadeusz R
61
61
add a comment |
add a comment |
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
StackExchange.ready(
function ()
StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53238325%2fformatdatetime-how-to-display-nanoseconds%23new-answer', 'question_page');
);
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Post as a guest
Sign up or log in
StackExchange.ready(function ()
StackExchange.helpers.onClickDraftSave('#login-link');
);
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
Sign up using Google
Sign up using Facebook
Sign up using Email and Password
