Jump to content


  • 0
Sebastian

Reporting and reading from SQL database

Question

Hello everyone, i'm working on a script which will make complete reportings from SQL. However, i'm stucked in a part of it, being this a 64 bit hexadecimal in a table which represents date and time for the mandatory date. I see a Mandatorysched

field but I don't understand the data since it's just a string of characters like "000B49C000080000" - has anybody else had this problem and solved it? I'm making the report tool (actually, a review tool) in VBs.

 

Any help will be much appreciated

 

Regards,

Share this post


Link to post
Share on other sites

2 answers to this question

Recommended Posts

  • 0
Hello Sebastian

 

Please specify what table/view and what column you are looking at and i will try to help you.

 

 

Hello wmmayms, thanks for commenting.

 

The view where it is is in

[MandatorySched] FROM [SMS].[dbo].[vAdvertisement]

 

Any help will be much appreciated.

 

Regards,

Share this post


Link to post
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Guest
Answer this question...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.

Loading...


×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.