Last name: Nightingale SDB Popularity ranking: 1104 This unusual name is of Anglo-Saxon origin, and is a nickname surname for someone with a good, sweet singing voice, from the bird, the nightingale.
You are doing everything right by using a to_date function and specifying the time. The time is there in the database. The trouble is just that when you select a column of DATE datatype from the database, the default format mask doesn't show the time.If you issue a. alter session set nls_date_format = 'dd/MON/yyyy hh24:mi:ss'.ou are doing everything right by using a to_date function and specifying the time. The time is there in the database. The trouble is just that when you select a column of DATE datatype from the database, the default format mask doesn't show the time.
up vote 1 down vote. I understand that you want to change the format of date& time columns for a SharePoint Site .Here are two options : 1.You can modify the view of the view in SharePoint Designer to format the date &time column.Change the formula to ddwrt:FormatDate(string($thisNode/@*[name()=current()/@Name]),1033,7) .hanks for your response 1. Solution works if we have few place to change but not for everywhere for example, created and modified date on each add/edit list\library forms 2. we can regional settings but not to specific format dd MMM yyyy I want to change date time format everywhere in sharePoint.