Lab Sql

I have publish up date and publish down date in my DB. Currently they are both same dates. How do I… Read more Add 30 Days For Date In Db

I have attendance record table like this +----------------+---------+-----------------------+ | NI… Read more Datetime String To Date, In Time And Out Time

It seems like it is not possible what I want(at least according to some articles i have read). But … Read more C# Convert String To Datetime Without Time

I'm struggling to get sqlldr to import a csv data file into my table, specifically with the fie… Read more Oracle Sqlldr Timestamp Format Headache

I have a RAW field in my Oracle database that represents the date of user registered in system. The… Read more Oracle Convert Raw To Date Format

Is there a way to convert a time object to a 12 hour format in SQL? I can't nessessarilly use d… Read more Sql Format Time Object From 24 Hour To 12

I try to spool output in a nice way, so i am formatting all VARCHAR2 columns to a5. However, my pro… Read more How To Format A Number Column In Oracle?

I was getting this error: 'Input string was not in a correct format.' Here is my Code: … Read more C# Error : Input String Was Not In A Correct Format