Date/timestamp Question

Legacy Poster

• 6 de febrero de 2015 16:30

Can anyone help me find where the date timestamp is located in the tables when a label is generated or printed? 

 

ive been looking in btprintjobs and i see createddatetime but its in this format.  635588140143470000   can anyone help me convert that to normal date/time in sql?

0

• 

  Legacy Poster

  ★ BarTender Hero ★

  • 6 de febrero de 2015 17:09

  Have a look at the scalar functions in the Bartender database (in SSMS).  They provided all the conversions as functions and you can use those to flip to 'normal' dates.  

  0

Iniciar sesión para dejar un comentario.