Direkt zum Hauptbereich

MySQL DayofWeek And Weekday Functions


 DayOfWeek
------------------

Returns the weekday index for date (1 = Sunday, 2 = Monday, …, 7 = Saturday). These index values correspond to the ODBC standard.


Weekday
------------

0 =  Monday , 1 = Tuesday, 2 = Wednesday, ...... Sunday = 6).


DayName
------------
Weekday name of the date.

Kommentare

Kommentar veröffentlichen

Beliebte Posts aus diesem Blog

How to - Web browser Control

 Creating a simple HTML Editor using Web brower control Create a basic Winform Appln. Drag a Webbrowser( end in the list ) from Toolbox. To  create buttons drag a Toolstrip control (near webbrowser ctrl in the list 'Commoncontrols' ) from Toolbox. You can add buttons, text box, progressbar etc by clicking. c   To make the Web browser control editable you have to write the following code while initializing.   InitializeComponent();    webBrowser1.DocumentText = "<HTML><BODY contentEditable='true'></BODY></HTML>";                      toolStripComboFontSize.SelectedIndex = 2; Double click on buttons to generate events. Variable possibilities are there . Some are given below, 1. Change text color  if (colorDialog1.ShowDialog() == DialogResult.OK)           ...
Kommentar veröffentlichen
Mehr anzeigen

Stored Procedure Returns GUID

This stored procedure returns GUID (GUIDColname) as output. Use databasename; Go CREATE PROCEDURE dbo.procname @Col1image, @Col2 varchar(50), @Col3varchar(5) AS     INSERT INTO dbo.tblname (Col1, Col2, Col3)     OUTPUT inserted.GUIDColname     values (@Col1,@Col2,@Col3) GO & the query looks like INSERT INTO dbo.tblname (Col1, Col2, Col3)     OUTPUT inserted.GUIDColname     values (null,null,null)
Kommentar veröffentlichen
Mehr anzeigen