I retrieve a record from a SQL Server 6.5 and one of the fields contains a date value. The server gives me the date in dd/mm/yyyy format and I store it into a variable.
This date variable is in d...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10058543.html
I tried mm/dd/yyyy, it doesnot accept it.
Thanks.
Shane
http://www.experts-exchange.com/Database/Oracle/Q_10062531.html
Zones:
OracleDate Answered: 07/09/1998 Grade: A Views: 0
I have got some value of the date.
Year: strYear
Month: strMonth
Day: strDay
Hour: strHour
Minute: strMinute
Second: strSecond
Now I want to check if it is a avaliable date.
In amer...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10157282.html
Zones:
Visual BasicDate Answered: 05/04/1999 Grade: A Views: 0
Hi! My question is -
In order for the function StrtoDateTime to convert a string into a Tdatetime to work, I need to change the system date and time format to mm/dd/yy hh:mm:ss to match the Strtod...
http://www.experts-exchange.com/Programming/Languages/Pascal/Delphi/Q_10160901.html
How do I obtain the system date n time? Every pc's system date n time is set to a different format, for example...
1999-05-06 or 06-05-1999 or 06/05/1999. What's the command to use to get the for...
http://www.experts-exchange.com/Programming/Languages/C/Q_10195679.html
Zones:
CDate Answered: 02/22/2002 Grade: A Views: 0
Is there a way to force inside of VB the date as MM/DD/YYYY
regardless of what is selected in regional settings. I need
this to remain in effect as long as the program is open for
all dates. Th...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10203452.html
Zones:
Visual BasicDate Answered: 01/10/2000 Grade: C Views: 0
How do i set the format in the server ,
as DD-MON-YYYY as a default date format?
I have tried specifing in init.ora
as
NLS_DATE_FORMAT="DD-MON-YYYY".
didn't work .
And i also tried by...
http://www.experts-exchange.com/Database/Oracle/Q_10252866.html
Zones:
OracleDate Answered: 01/04/2000 Grade: C Views: 0
Hi,
I'm trying to execute the query
select to_date(to_char(completed_date,'YYYYMMDD')
|| completed_time,'YYYYMMDDHH24:MI') from change_order
and I'm getting the error :
Ora 1840 Input ...
http://www.experts-exchange.com/Database/Oracle/Q_10279103.html
Zones:
OracleDate Answered: 01/31/2000 Grade: B Views: 20
How must I proceed to know which
is the current format of the date used in the system in order to initialise
the format date in the control dates
of the forms ?
(by using API ? Could you prov...
http://www.experts-exchange.com/Programming/Languages/Visual_Basic/Q_10293495.html
Zones:
Visual BasicDate Answered: 02/14/2000 Grade: A Views: 0
How can I do the equivalent of
select format$(StartDate,"yyyymmdd") from MyTable
in SQL Server
I've tried
select datepart(year,startdate)+datepart(month,startdate)+datepart(day,startdat...
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/Q_10314793.html
