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 make and use web service in Microsoft Dynamics Navision.

Image
Web services is use to do operation on data of NAV from outside the NAV environment, you can’t insert, update, delete the data of NAV using web service with proper authentication. For creating the web service in NAV follow below steps. (Here we are making the web service with gives vendor name based on vendor number. And we consume this service in windows application outside the NAV area.) Open NAV development environment and create the new code unit. Make one function “GetVendorName” Function name: GetVendorName Input Parameter : VendorNumber Output (Return) parameter : VendorName Now write below code in function. IF Vendor.GET(VendorNo)THEN BEGIN     EXIT(Vendor.Name); END ELSE BEGIN     EXIT('Vendor Not Found'); END Now save this codeunit with proper Id and Name. Now open the client application module and search for ‘Web service’ in search text box.  Open the “Web service page” and click on “NEW” button, it will ask following details Object Type: Codeunit Obj...
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