DateTime data insert to sql server

[Shyam_Pragash]

Hi @Anil_G

Thanks :). i can able to insert the data in sql server…

but i have on issue… wrong data inserted to sql server…

Time is missing…

Thanks
Shyam

[Anil_G (Anil Gorthi)]

HI @Shyam_Pragash

Please use DateTimeValue(Variable) instead of DateValue

Happy Automation

Forum FAQ - How to mark a post as a solution

Forum FAQ - How to mark a post as a solution This document is part of our beginners guide. This article will teach you how to properly mark a post as a solution. We were closely following our last UiPath Forum feedback round! topic and carefully extracted all the bits of feedback that was provided. As such, we would like to tackle the topic of solutions on our Forum and how to properly use them. When is the topic resolved? The topic can be considered resolved when the topic author has fo…

cheers

[Shyam_Pragash]

@Anil_G

DateTimeValue(Variable)

DateTimeValue function not available… can u tell me how to add ?

Thanks
Shyam

[Anil_G (Anil Gorthi)]

Hi @Shyam_Pragash

Try timevalue or a combination of datevalue and timevalue

cheers

[Shyam_Pragash]

Hi @Anil_G @RajKumar_DC

Thanks All

Finally we found the soluation to import Null data with specificed variable types in sql server.

If ( String.IsNullOrEmpty(Exl_Created_At), New Nullable(Of Date), System.Convert.ToDateTime(Exl_Created_At))

Variable Type : Nullable.System.Datetime

Thanks
Shyam

[william_joe]

The simplest method to insert the current date and time in MySQL is to use the now() function. Once you call the function, it returns the current date and time in the system’s configured time zone as a string. The value returned from the now() function is YYYY-MM-DD for the date and HH-MM-SS-UU for the time record.

Regards,
Will