Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
hello Community
I'm sort of new in QV.
I created qvd file from db. Using this sample script:
table_name:
load * ;
sql select *
from .....
store table_name into 'table_name.qvd';
after this don't know why after my date field some zeroes added. example 20110511.00 like this. also some fields looks like date is got this zeroes. In database date format is fine. Can anybody tell mi how to solve this. And please explain why?
Kind regards
Muncho
Hi
while loading use Data(Date_field) as date
in your script to avoid this proble.
hope that helps
Regards
ASHFAQ
Hi
while loading use Data(Date_field) as date
in your script to avoid this proble.
hope that helps
Regards
ASHFAQ
Hi ASHFAQ
Thanks for date() xD.
I thought date_field date format fine in our DB. But it was not. I used date#() and now its fine.
that was easy as pie ^^