how to change date-time format to DD-Mon-YYYY HH:MM:SS (ie. 05-May-2015 16:41:35)

how to change date-time format to DD-Mon-YYYY HH:MM:SS (ie. 05-May-2015 16:41:35)

Dear All,

SELECT LONGTODATE(wo.CREATEDTIME) "Created Time" from WorkOrder wo

how to change date-time format to DD-Mon-YYYY HH:MM:SS (ie. 05-May-2015 16:41:35)

please help

Thanks
Win

        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?
                See all integrations
                New to ADManager Plus?

                  New to ADSelfService Plus?

                  Start your free trial
                  Start your free trial

                        Related Products