How to make this DATE format

Transact-SQL

Index ‹ SQL Server

- Previous
  - 1
    - Permissions to view Stored Procedure Property I have done that for the developer group and I still get this error on Stored Procedures TITLE: Microsoft SQL Server Management Studio ------------------------------ Cannot show requested dialog. ------------------------------ ADDITIONAL INFORMATION: Cannot show requested dialog. (SqlMgmt) ------------------------------ Property DefaultSchema is not available for Database '[HouseAccounting]'. This property may not exist for this object, or may not be retrievable due to insufficient access rights. (Microsoft.SqlServer.Smo) For help, click: http://go.microsoft.com/fwlink ProdName=Microsoft+SQL+Server&ProdVer=9.00.2047.00&EvtSrc=Microsoft.SqlServer.Management.Smo.ExceptionTemplates.PropertyCannotBeRetrievedExceptionText&EvtID=DefaultSchema&LinkId=20476 ------------------------------ BUTTONS: OK ------------------------------ The Developers can look at the properties of tables, views, and functions but not stoerd procedures. Tag: How to make this DATE format
  - 2
    - data file blanks to nulls If you are using FlatFile source to read the data, try enbaling the checkbox that says "Retain null values from the source as null values in the data flow" in the Flat File Source editor. Hope this helps... Tag: How to make this DATE format
  - 3
    - Send an email on non-fatal errors from Data Flow Bob Bojanic wrote: Hi Sandy, you should try to use Event Handlers. Event Handlers will allow you to build additional control flows that get activated by events (OnError, OnWarning, etc) posted from executables (a data flow in your case) you are monitoring. HTH. Bob, an error handler shouldn't fire (should it ) if Sandy is redirecting error rows in the data flow. Tag: How to make this DATE format
  - 4
    - Service Broker "TO service could not be found" Message origin: "Transport" OK, I thought you might be onto something that I missed. While that may have been a problem - it didn't fix the issue. I still get the same message in Profiler on the target machine and no reasons in the transmission_status (empty). Any other ideas...anyone Tag: How to make this DATE format
  - 5
    - Distinct Count with Junk Dimension Attribute Hi, It works fine when we are making Calculated Members, but when Analysis Services 2005 has introduced Junk Dimension Concept. So I feel it should give facility to add Distinct Count Cube Measure based on its [Junk Dimension] associated Attribute Dimensions. As per my understanding if there is Junk Dimension and we have very important Attribute Dimension, in Junk Dimension, On which I have to add Distinct Count Measure which can be used across all combination, In that situation we can not, because I can add Distinct Count only on JunkID which will be wrong or not of my use, As I have explained above. But we can add Several Calculated members as per our need. Thanks Bryan C. Smith for your suggestion overall it was helpfull. Bhudev Tag: How to make this DATE format
  - 6
    - Trying to set output variable to row count result of SQL Execute Task Try adding an alias to the result column. SELECT count(*) AS ItemCount FROM hsi.itemdata a (The fact that it is an expression should have no impact. For testing I would stop using an expression and get it working with a static SQL statement, it often helps to simplify a problem process.) Tag: How to make this DATE format
  - 7
    - How can I set SO_TIMEOUT on the sockets used by the JDBC 2005 driver? Thanks but I need clarification- The description of this method states that this is the amount of time the query will be allowed to execute. Is this enforced by the client or by the server Also- I see in the connection string properties there is a lock timeout specified as: The number of milliseconds to wait before the database reports a lock time-out. The default behavior is to wait indefinitely. If it is specified, this value is the default for all statements on the connection. Note that Statement.setQueryTimeout() can be used to set the time-out for specific statements. The value can be 0, which specifies no wait. So this makes me think that setQueryTimeout and lock timeout connection property are the same thing, but they are NOT the same thing. In my case, our customer is experiencing some kind of network condition that is not being propegated back to our code. The result is we have a transaction that is open (blocking) on the database that is waiting for a commit or rollback, but the driver never returns to our code. So this transaction ends up blocking other transactions. We have set lock timeout on the connection and this results in the second, third, etc. transactions to eventually fail with a lockTimeout exception, but the original transaction stays open still blocking. So what we want is a socket timeout (ex. SO_TIMEOUT in win32 api or socket.setSoTimeout in java) to be able to set this. If setQueryTimeout will accomplish then great, but if this just ends up adding a lock timeout then this wont solve the problem. Note as well that whatever this magical network condition is seems to be a problem for many database drivers running in windows (jtds, ibm db2, etc) and they all implement a socket timeout as a workaround. Thanks, Steve Tag: How to make this DATE format
  - 8
    - xquery - order by problem Hi! Great, it does what I look for! Now I hope it solves my problem with sorting in Management Studio. If you now an good link about xml/xquery/xpath in Sql Server, pleas let me now (-: I read other examples on internet, and don't understand why my 1. try didn't work; Is it wrong, or has it something to do with MS implementation /Bjorn Tag: How to make this DATE format
  - 9
    - Very hard question on how to query data and return by months sql 2003 Tag: How to make this DATE format
  - 10
    - Database attach at setup Embedded database feature is only available in SQL Server Express. In express, in connection string you can mention UserInstance and attach mdf file. But in all other versions, you will have to attach the database using some sqlscript explicitly. And also connection string will differ in both method Refer this link for userinstance : http://blogs.msdn.com/sqlexpress/archive/2006/11/22/connecting-to-sql-express-user-instances-in-management-studio.aspx Madhu Tag: How to make this DATE format
  - 11
    - File System Watcher can not read excel from SharePoint What is the path you are using I think of sharepoint files as being accessed via http, and of course it will not work for that. Tag: How to make this DATE format
  - 12
    - how to set date field in sql server 2005 table You can see responses to your duplicate post here . Please avoid duplicate posting. This post is now locked. Tag: How to make this DATE format
  - 13
    - SQLSTATE 42000- Error 15404 with ADS We are using the Local system account Tag: How to make this DATE format
  - 14
    - HOW TO: Print a report directly to a printer OKay, I made some modifications to the whole class. This prints reports beautifully. Pass in parameters you want and it prints eihter in landscape or portrait. here is the code.. Imports System.Drawing.Imaging Imports System.Drawing.Printing Imports System.IO Imports System.Web.Services.Protocols Imports PrintReport.ReportExecution Imports System.Runtime.InteropServices ' For Marshal.Copy Imports Rockwood 'Custom object Imports Microsoft.reportingservices.Interfaces Namespace PrintReport # Region "Main" Friend Class Main Private m_sPrinterName As String Private m_sReportName As String Private m_sNumCopies As Integer Private m_aParam As ParamsDictionary Private m_bPrintOrient As String <STAThread()> _ Public Sub Main( ByVal args As String ()) Dim pe As PrintMain = New PrintMain() pe.PrintReport(m_sPrinterName, m_sReportName, m_bPrintOrient, m_sNumCopies, m_aParam) End Sub Public Property pPrintOrient() As Boolean Get Return m_bPrintOrient End Get Set ( ByVal value As Boolean ) m_bPrintOrient = value End Set End Property Public Property pPrinterName() As String Get Return m_sPrinterName End Get Set ( ByVal value As String ) m_sPrinterName = value End Set End Property Public Property pReportName() As String Get Return m_sReportName End Get Set ( ByVal value As String ) m_sReportName = value End Set End Property Public Property pNumCopies() As Integer Get Return m_sNumCopies End Get Set ( ByVal value As Integer ) m_sNumCopies = value End Set End Property Public Property pParam() As ParamsDictionary Get Return m_aParam End Get Set ( ByVal value As ParamsDictionary) m_aParam = value End Set End Property End Class # End Region # Region "PrintMain" Friend Class PrintMain Private rs As New ReportExecutionService() Private m_renderedReport As Byte ()() Private m_delegate As Graphics.EnumerateMetafileProc = Nothing Private m_currentPageStream As MemoryStream Private m_metafile As Metafile = Nothing Private m_numberOfPages As Integer Private m_currentPrintingPage As Integer Private m_lastPrintingPage As Integer Private mGlobals As globals 'Custom logging and error handling Public Sub New () mGlobals = New globals ' Create proxy object and authenticate rs.Credentials = System.Net.CredentialCache.DefaultCredentials rs.Url = My .Settings.ReportExecutionService End Sub Private ReadOnly Property mlog() As LogUtil 'Custom logging and error handling Get Return mGlobals.Log End Get End Property Private ReadOnly Property Msgs() As Messages 'Custom logging and error handling Get Return mGlobals.erMsg End Get End Property Public Function RenderReport( ByVal reportPath As String , Optional ByVal aParams As ParamsDictionary = Nothing ) As Byte ()() ' Private variables for rendering Dim deviceInfo As String Dim format As String = "IMAGE" Dim firstPage As Byte () = Nothing Dim encoding As String = "" Dim mimeType As String = "" Dim warnings As Warning() = Nothing Dim reportHistoryParameters As ParameterValue() = Nothing Dim streamIDs As String () = Nothing Dim pages As Byte ()() = Nothing Dim historyID As String = Nothing Dim showHideToggle As String = Nothing Dim execInfo As New ExecutionInfo Dim execHeader As New ExecutionHeader() Dim SessionId As String Dim extension As String = "" Try mGlobals = New globals 'Custom logging and error handling mGlobals.appName = My .Application.Info.AssemblyName 'Custom logging and error handling mGlobals.appVersion = My .Application.Info.Version.ToString 'Custom logging and error handling rs.ExecutionHeaderValue = execHeader execInfo = rs.LoadReport(reportPath, historyID) ' Prepare report parameter. If Not aParams Is Nothing Then Dim parameters(aParams.Count - 1) As ReportExecution.ParameterValue Dim i As Integer = 0 For i = 0 To aParams.Count - 1 parameters(i) = New ReportExecution.ParameterValue() parameters(i).Name = aParams(i).Name parameters(i).Value = aParams(i).Value Next rs.SetExecutionParameters(parameters, "en-us" ) End If SessionId = rs.ExecutionHeaderValue.ExecutionID ' Build device info based on the start page deviceInfo = String .Format( "<DeviceInfo><OutputFormat>{0}</OutputFormat></DeviceInfo>" , "emf" ) 'Exectute the report and get page count. ' Renders the first page of the report and returns streamIDs for subsequent pages firstPage = rs.Render(format, deviceInfo, extension, encoding, mimeType, warnings, streamIDs) ' The total number of pages of the report is 1 + the streamIDs m_numberOfPages = streamIDs.Length + 1 pages = New Byte (m_numberOfPages - 1)() {} ' The first page was already rendered pages(0) = firstPage Dim pageIndex As Integer = 1 Do While pageIndex < m_numberOfPages ' Build device info based on start page deviceInfo = String .Format( "<DeviceInfo><OutputFormat>{0}</OutputFormat><StartPage>{1}</StartPage></DeviceInfo>" , "emf" , pageIndex + 1) pages(pageIndex) = rs.Render(format, deviceInfo, extension, encoding, mimeType, warnings, streamIDs) pageIndex += 1 Loop Catch ex As SoapException Msgs.appendException(ex) 'Custom logging and error handling Catch ex As Exception Msgs.appendException(ex) 'Custom logging and error handling Finally Msgs.writeMessagesToLog( True ) 'Custom logging and error handling End Try Return pages End Function Public Function PrintReport( ByVal printerName As String , ByVal ReportName As String , ByVal PrintOrient As Boolean , Optional ByVal NumCopies As Integer = 0, Optional ByVal aParam As ParamsDictionary = Nothing ) As Boolean Me .RenderedReport = Me .RenderReport(ReportName, aParam) Try ' Wait for the report to completely render. If m_numberOfPages < 1 Then Return False End If Dim pageSettings As System.Drawing.Printing.PageSettings = New System.Drawing.Printing.PageSettings pageSettings.Landscape = PrintOrient pageSettings.Margins.Bottom = 0 pageSettings.Margins.Top = 0 pageSettings.Margins.Left = 0 pageSettings.Margins.Right = 0 Dim printerSettings As PrinterSettings = New PrinterSettings() printerSettings.MaximumPage = m_numberOfPages printerSettings.MinimumPage = 1 printerSettings.PrintRange = PrintRange.SomePages printerSettings.FromPage = 1 printerSettings.ToPage = m_numberOfPages printerSettings.Copies = NumCopies printerSettings.PrinterName = printerName Dim pd As PrintDocument = New PrintDocument() m_currentPrintingPage = 1 m_lastPrintingPage = m_numberOfPages pd.DefaultPageSettings = pageSettings pd.PrinterSettings = printerSettings ' Print report AddHandler pd.PrintPage, AddressOf pd_PrintPage pd.Print() Msgs.addInfo( "Report: '{0}' on printer : '{1}' for '{2}' copies completed successfully " , ReportName, printerName, NumCopies) 'Custom logging and error handling Catch ex As Exception Msgs.appendException(ex) 'Custom logging and error handling Finally Msgs.writeMessagesToLog( True ) 'Custom logging and error handling End Try Return True End Function Private Sub pd_PrintPage( ByVal sender As Object , ByVal ev As PrintPageEventArgs) ev.HasMorePages = False If m_currentPrintingPage <= m_lastPrintingPage AndAlso MoveToPage(m_currentPrintingPage) Then ' Draw the page ReportDrawPage(ev.Graphics) ' If the next page is less than the last page, print another page. If m_currentPrintingPage < m_lastPrintingPage Then m_currentPrintingPage += 1 ev.HasMorePages = True End If End If End Sub ' Method to draw the current emf memory stream Private Sub ReportDrawPage( ByVal g As Graphics) If Nothing Is m_currentPageStream OrElse 0 = m_currentPageStream.Length OrElse Nothing Is m_metafile Then Return End If SyncLock Me ' Set the metafile delegate. Dim width As Integer = m_metafile.Width Dim height As Integer = m_metafile.Height m_delegate = New Graphics.EnumerateMetafileProc( AddressOf MetafileCallback) ' Draw in the rectangle Dim points(2) As Point points(0) = New Point(0, 0) points(1) = New Point(width, 0) points(2) = New Point(0, height) g.EnumerateMetafile(m_metafile, points, m_delegate) m_delegate = Nothing End SyncLock End Sub Private Function MoveToPage( ByVal page As Int32) As Boolean ' Check to make sure that the current page exists in the array list If Nothing Is Me .RenderedReport(m_currentPrintingPage - 1) Then Return False End If ' Set current page stream equal to the rendered page m_currentPageStream = New MemoryStream( Me .RenderedReport(m_currentPrintingPage - 1)) ' Set its postion to start. m_currentPageStream.Position = 0 ' Initialize the metafile If Not Nothing Is m_metafile Then m_metafile.Dispose() m_metafile = Nothing End If ' Load the metafile image for this page m_metafile = New Metafile( CType (m_currentPageStream, Stream)) Return True End Function Private Function MetafileCallback( ByVal recordType As EmfPlusRecordType, ByVal flags As Integer , ByVal dataSize As Integer , ByVal data As IntPtr, ByVal callbackData As PlayRecordCallback) As Boolean Dim dataArray As Byte () = Nothing ' Dance around unmanaged code. If data <> IntPtr.Zero Then ' Copy the unmanaged record to a managed byte buffer that can be used by PlayRecord. dataArray = New Byte (dataSize - 1) {} Marshal.Copy(data, dataArray, 0, dataSize) End If ' play the record. m_metafile.PlayRecord(recordType, flags, dataSize, dataArray) Return True End Function Public Property RenderedReport() As Byte ()() Get Return m_renderedReport End Get Set ( ByVal value As Byte ()()) m_renderedReport = value End Set End Property Protected Overrides Sub Finalize() MyBase .Finalize() End Sub End Class # End Region # Region "Parameters Section 2 classes" # Region "Params Class" Public Class Params Private mID As Integer Private mName As String Private mValue As String Public Sub New ( ByVal id As Integer , ByVal name As String , ByVal value As String ) mID = id mName = name mValue = value End Sub Public Property ID() As Integer Get Return mID End Get Set ( ByVal Value As Integer ) mID = Value End Set End Property Public Property Name() As String Get Return mName End Get Set ( ByVal Value As String ) mName = Value End Set End Property Public Property Value() As String Get Return mValue End Get Set ( ByVal Value As String ) mValue = Value End Set End Property End Class # End Region # Region "Dictionary Class" Public Class ParamsDictionary Inherits DictionaryBase Public Sub Add( ByVal param As Params) MyBase .Dictionary.Add(param.ID, param) End Sub Public Sub Add( ByVal id As Integer , ByVal name As String , _ ByVal value As String ) MyBase .Dictionary.Add(id, New Params(id, name, value)) End Sub Public Sub Remove( ByVal id As Integer ) MyBase .Dictionary.Remove(id) End Sub Public Sub Remove( ByVal param As Params) MyBase .Dictionary.Remove(param.ID) End Sub Public Function Contains( ByVal param As Params) As Boolean Return MyBase .Dictionary.Contains(param.ID) End Function Public Function Contains( ByVal id As Integer ) As Boolean Return MyBase .Dictionary.Contains(id) End Function Default Public Property Item( ByVal id As Integer ) As Params Get Return MyBase .Dictionary.Item(id) End Get Set ( ByVal Value As Params) MyBase .Dictionary.Item(id) = Value End Set End Property Protected Overrides Sub Finalize() MyBase .Finalize() End Sub End Class # End Region # End Region End Namespace here is a sample form code to get it going. Private Sub Form1_Load( ByVal sender As Object , ByVal e As System.EventArgs) Handles Me .Load txtRName.Text = "/Com/ElectronicInvoice" 'test default txtPrintPath.Text = "\\path\laserjet1150" 'test default txtNumCopies.Text = 1 ' default End Sub Private Sub Button1_Click( ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click Dim oPrint As PrintReport.Main = New PrintReport.Main Dim args() As String oPrint.pPrinterName = txtPrintPath.Text.ToString oPrint.pNumCopies = CInt (txtNumCopies.Text) oPrint.pReportName = txtRName.Text.ToString Dim oParams As PrintReport.ParamsDictionary = New PrintReport.ParamsDictionary oParams.Add(0, "InvoiceNumber" , "S0606430" ) 'add as many paramters as you want or None at all. oPrint.pParam = oParams oPrint.pPrintOrient = True 'landscape = true oPrint.Main(args) End Sub Tag: How to make this DATE format
  - 15
    - LAG MDX statement Cheers, I'll try that & get back to you. I had tried .CurrentMember with no success.... MemberValue hadn't occurred to me (!) Tag: How to make this DATE format
  - 16
    - Looking for the equivalence (date issue) Thanks for that. It'll be tested. Tag: How to make this DATE format
- Next
  - 1
    - Can't figure out this error! My logic is messed up. Execution was going to the "Else" portion on the rows it wasn't supposed to (that's why it was throwing the index out of bounds error). What is the syntax for "not like" Thanks Tag: How to make this DATE format
  - 2
    - How to avoid non-published columns deletion on subscriptions' reset Hi Hilary, I have been doing some more tests with this, and I realized there is no problem with the identities. The real problem is since I changed the "Action if name is in use" to " keep the current object without changes" in the publication articles' properties, there is no replication. I changed this option to take default value, and the replication works again. But when I restart the subscription, the table at the subscriber's side is deleted, and I lose all the "unsubscribed" data. Is there any way to solve this Regards Tag: How to make this DATE format
  - 3
    - Instead of INSERT trigger!! Hi, Thanks for your help. Well, I had an opinion telling me to: put begin ... end in each if block if ... begin ... end else begin ... end if I don't have them then if uses only the 1st statement What do you think Does both solutions give the same result Thanks Tag: How to make this DATE format
  - 4
    - Urgt Pls:Cell merge prob Thanks for reply, I am using Table control to generate the report.eventhough My table does not contain any merged cells , the generated Excell sheet reprsents merged collums of data. regards Sithender.S Tag: How to make this DATE format
  - 5
    - Referencing an alias in a where clause Its SQL 2000, and I haven't actually set the @project as any data type - could that be the problem The actv.projID is char. Actually, I may not have been clear in the problem. When running the data set, it will work fine, but when I try to preview the report, and enter a 4 digit @project, I get a blank report with no error. Thanks for the info on not using column alias! Tag: How to make this DATE format
  - 6
    - Execute SQL Task: variable mapping failed with complex SQL script. Please help! You could also use an expression on the precedence constraint leading to the ExecuteSQL task. Tag: How to make this DATE format
  - 7
    - MSSQL_REPL55012: An unspecified error had occurred in the native SQL Server connection component. Hi Ekrem, As I mentioned, I am a student and this is my first attempt at working with SQL Server. I am not familiar with what you mean by "configure Distributor, Publisher and Subscriber frame first." I can tell you that I am closely reading and executing each step of the walkthrough (link provided in my original post) in the order it is written. So far, I have done the following in this order: * Create a database and populate with data ( Successful ) * Prepare the Server for Publishing Data - Create the snapshot user account ( Successful ) - Create the snapshot folder ( Successful ) - Create a publication ( Successful ) * Set permissions - Set database permissions ( Successful ) - Grant publication access ( Successful ) * Create the Publication Snapshot - Create the publication snapshot ( Error occurs at this step ) If you think I should be completing/configuring something else, please let me know. I apologize in advance, but you'll need to explain to me what to do. Thanks again for your help Ekrem. It is much appreciated. Tag: How to make this DATE format
  - 8
    - Log Shipping Thank you for the repsonse, I will test out in my dev environment. Regards, Sean Tag: How to make this DATE format
  - 9
    - Move data to DB2 on AS400 with SSIS What is the error Also, you can't use an out-of-the-box solution against an ODBC destination. You are correct in using the OLEDB for DB2 driver. I use it for my source pulls, but don't use it for destinations so I'm not much help there without knowing your error. Tag: How to make this DATE format
  - 10
    - sql server perfprmance Hi, I have table with 35 columns and 500,000 rows. I have a primary key on this table. when I retieve data with parameters (StartDate and EndDate) it is taking 1 minute on 2 GB RAM machine. how can I retrieve the data in lesser time say in 15 seconds. any help is appreciated. Thanks, Srik Tag: How to make this DATE format
  - 11
    - Passing Variables from URL and DDL combined Nope... Here's the issue. Parameter2 Dataset needs to also include the GUID Select Value, Lable from Table2 Where FilterField in ( @Parameter1) AND GUID = @Guid The problem is that with this it both GUID in DDL 1 and 2. so how do we get the GUID to persist from the URL Tag: How to make this DATE format
  - 12
    - Instance Name of SQL Server 2005 Standard when you have installed sql server standard (for that matter any edition) you will be asked whether u want to install Default Instance or Named Instance. Default instance will have the same name of your Physical Machine name and named instances will have Machinename\Nameof the instance. Just to see whether you have any instances running , just open Command window c:\ sqlcmd -L you will get all the instances running in the network. check howmany instance are there with your physical machine name Madhu Tag: How to make this DATE format
  - 13
    - Problems installing Reporting Services It doesn't seem you read my question very carefully. Tag: How to make this DATE format
  - 14
    - Adding Time In DateTime Field Please check your objective. All of the times you list are afternoon times. The sum of the time component for all of these is the 5:45 plus an additional 36 hours. If your answer is correct, there is more to it than just summing the time components. Code Snippet declare @aTable table (field1 datetime) insert into @aTable select '01/02/2007 01:00:00PM' union all select '01/03/2007 01:45:00PM' union all select '01/04/2007 03:00:00PM' select datediff(day, 0, sumOfTime) as Days, convert(varchar, sumOfTime, 114) as Time from ( select cast(sum(cast(field1 as float) -floor(cast(field1 as float)))as datetime) as sumOfTime from @aTable ) x /* Days Time ----------- ------------------------------ 1 17:44:59:997 */ Tag: How to make this DATE format
  - 15
    - Large table search performance What type of partition will give me the best performance vertical or horizontal In horizontal partition what is the best way to do it: How mane tables Witch column on each table The query that do all the problems is the search query and it use 14 columns in the ��WHERE�� statement, maybe it best to divide the table into 2 table that one will hold the 14 columns for the search query and the second table will hold the rest of the columns is this will give best performance Tag: How to make this DATE format
  - 16
    - Win 2K3 x64 Connection Issues I'm trying to connect to a database on IIS 6 under W2K3 x64 R2. I have to keep IIS running in 64 bit mode, as we are also running exchange 2007 on this machine. The website (written in classic ASP) used to run on a W2K Server and connected to an access database using first the MS Access driver, then later the Jet 4.0 drivers. Both of these fail on the new machine. This is my first real attempt to use a SQL server (any version, any flavor, any vendor). I keep running into errors connecting, the error is a provider error. Did I screw something up or does SQL Express not run under these conditions Thanks for any help, Andrew Pometti Tag: How to make this DATE format

Dan Mikkelsen

im having some trouble getting this specifik date format:

dd-MM-yyyy hh:mm

where the time is in 24 hour format...

Date and time formatting seems a lot harder in sql server 2005 than in access

Top

Re: How to make this DATE format

Arnie Rowland

This:

SELECT convert( varchar(16), getdate(), 120 )

Returns:

----------------

2007-05-07 13:04

Refer to Books Online, Topic: 'Cast and Convert' for the 'style' (120, above) values.

Top