How to get and time as simple string?


SimpleCode :

select REPLACE(REPLACE(REPLACE(REPLACE(convert(varchar,getdate(),121),'-',''),':',''),'.',''),' ','') as StrDateTimr


OUTPUT:

--
/\/ir@\/  <(.'.)>

Comments

Post a Comment

Popular posts from this blog

How to use serial.write() in Arduino.

Image
-           First you have to declare it with board rate 9600 Serial.begin(9600);    -           Then we check is serial port is available. If available then we write data to it. if (Serial.available()>0) {       Serial.Write(byte data); }
Read more

How to Generate random rows in dataset using c#.net

Image
For generating the random rows from the data set first you have to generate the random numbae and this number is pass to the dataset CODE:  SqlConnection con = new SqlConnection("Data Source=NIRAV-PC;Initial Catalog=Student;Integrated Security=True");             con.Open();             string str = "select * from StudentDetail";             SqlCommand cmd =new SqlCommand(str,con);             SqlDataAdapter sda = new SqlDataAdapter(cmd);             DataSet ds =new DataSet();             sda.Fill(ds);             Random RandomNumber = new Random();          ...
Read more

How to use Format function in Microsoft Dynamics Navision.

Image
Format function is use to display date in various format some example given below. Format function take 3 input argument First: date which you want o display Second: number of character return by default is 0 (o means return all the string) Third: string format in witch you want to convert. Example: 1 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,'<Month Text> <Day,2> <Year4>')); OURPUT: Emaple:2 MESSAGE('Today  date is : %1 ', FORMAT(TODAY,0,' <Day,2> <Month,2> <Year4>')); OUTPUT:
Read more