creating QVD file problem

[#1]

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

[ashfaq_haseeb · Accepted solution]

Hi

while loading use Data(Date_field) as date

in your script to avoid this proble.

hope that helps

Regards

ASHFAQ

[#3]

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 ^^