Format date

Format date

I'm using ServiceDesk Plus 9.4 with MSSQL 

I have this query SELECT substring(workstation.biosdate,1,8) 'Bios Date' FROM SystemInfo workstation which works, I get 20080825, but I want to convert it to 25/08/2008, I tried with convert and dateadd with no luck


        New to M365 Manager Plus?
        New to M365 Manager Plus?
          New to RecoveryManager Plus?
          New to RecoveryManager Plus?
            New to Exchange Reporter Plus?
            New to Exchange Reporter Plus?
              New to SharePoint Manager Plus?
              New to SharePoint Manager Plus?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial





                            Related Products