Skip to content

Sqljunkieshare

  • Home
  • About

Tag: Oracle

How to get name of the day or day of the week in SQL Server ,Oracle and Mysql

January 11, 2013Leave a comment

 

Sql server has a date function  called DATENAME to get the name of the day or day of week

 

 

Image

 

Oracle day name or day of week function

Image

 

Mysql has a similar function called dayname() which is equivalent to datename in Microsoft SQL server 

Image

 

Recent Posts

  • Create RMAN Catalog and Register a Database in 12c
  • Setup SQL Agent alerts for User Error Messages
  • Failed to initialize sqlcmd library with error number -2147467259 [solved]
  • Log SQL Errors using Extended Events
  • Quickly Backup a Table and Import later
  • QuickTiP: Setup TNS less connection to Oracle in SSIS
  • FIX:OLE DB provider for linked server returned message “Query timeout expired”.
  • Simple powershell script to Bulk Load csv into a SQL Server table.
  • [FIX]The DELETE statement conflicted with the REFERENCE constraint FK_subplan_job_id. The conflict occurred in database msdb, table dbo.sysmaintplan_subplans, column job_id. The statement has been terminated
  • [solved] Docker and Windows 10 hyper-v Containers, byLinuxVM’ failed to start.. . Virtual machine ‘MobyLinuxVM’ could not be started because the hypervisor is not running

Categories

  • Administration
    • DBCC
    • Docker
    • Power Shell
  • Aurdino
  • Database Design – SQL server 2008, 2008R2 & 2012
    • SQL 2016
  • Hadoop
  • Oracle
  • R
  • SQL
    • Built-in T-SQL Functions (Updated SQL 2012))
      • Scalar Functions
        • Configuration Functions
        • Date time functions
        • String Functions
    • SQL SERVER 2012
      • TSQL 2012 New Features
    • SSIS
    • SSRS
      • Data Visualization
  • SSAS
    • MDX
  • Uncategorized

Sqljunkieshare

Sqljunkieshare

Blog Stats

  • 848,002 hits
Create a free website or blog at WordPress.com.
Privacy & Cookies: This site uses cookies. By continuing to use this website, you agree to their use.
To find out more, including how to control cookies, see here: Cookie Policy
  • Follow Following
    • Sqljunkieshare
    • Join 41 other followers
    • Already have a WordPress.com account? Log in now.
    • Sqljunkieshare
    • Customize
    • Follow Following
    • Sign up
    • Log in
    • Report this content
    • View site in Reader
    • Manage subscriptions
    • Collapse this bar