9 More Discussions You Might Find Interesting
1. Programming
Hi Team ,
I am new to Sybase Adaptive Server Enterprise/15.7 (ASE) and need some guidance to find the different values in serial format column.
SELECT DISTINCT SERIAL_FORMAT FROM PRODUCTS
It has values with below format which contains 12 digits hexadecimal characters with... (2 Replies)
Discussion started by: Perlbaby
2 Replies
2. Shell Programming and Scripting
Hi All,
Could you please provide the shell script to find number of weekdays and
number of weekends for a given date for that month.
Monday to friday should be considered as weekdays and Saturday and Sunday should be considered as weekends.
Date should be passed as parameter.
For... (13 Replies)
Discussion started by: ROCK_PLSQL
13 Replies
3. Emergency UNIX and Linux Support
Hi,
I'm facing an emergency situation, wherein I have to provide limited support to a Sybase DB temporarily as the DBA was fired. There is an urgent need of adding to users to the database. After some time on google, I was able to gather the below information on the database setup
... (1 Reply)
Discussion started by: maverick_here
1 Replies
4. Shell Programming and Scripting
I have requirement to connect to different sybase server's and store the data into flat file and load into oracle using sqlloader
for each day drop the table and re create it and load the data based on business date as parameter which was taking from parameter file.Any help on this should be... (0 Replies)
Discussion started by: mohan705
0 Replies
5. Shell Programming and Scripting
This is more a database problem than a shell one, but we have a problem affecting our scripts, so I'm stretching the limits a bit! ;)
We're in the process of migrating our application and a large number of associated scripts from Sybase 12.5.4 to Sybase 15. Scripts using 'isql' and 'bcp' include... (1 Reply)
Discussion started by: JerryHone
1 Replies
6. Shell Programming and Scripting
I am trying to bcp in using sybase::bcp perl module. I can find we can give user, pwd and server name in the parameters.
How can I give database and table name? (1 Reply)
Discussion started by: Deei
1 Replies
7. What is on Your Mind?
Its been a while since we had any fun polls or interesting topics in this forum.
So, here I start a thread rather calling it as a question - " What do you do during weekends ? :) "
For many, on hearing the term - weekends should excite them :b:
for ( few ) some - uhhh .. its just another day... (11 Replies)
Discussion started by: matrixmadhan
11 Replies
8. Shell Programming and Scripting
I am writing a shell script that verifies if a device is created on wrong mounts
1> sp_helpdevice
2> go | awk '{print $2}' | grep database | grep -v `df -k | grep /dev/dsk | awk '{print $6}'`
So if things are ok, the output should return nothing
If the result gives 1 or more entry, then... (1 Reply)
Discussion started by: melanie_pfefer
1 Replies
9. Solaris
Dear All
I have a problem that I can't connect from VB to Sybase 11.
Could you help me? (2 Replies)
Discussion started by: Than Chanroeun
2 Replies
TZ(5) File Formats Manual TZ(5)
NAME
TZ - Time zone environment variable
SYNOPSIS
TZ=zone[-]offset[dst[offset][,start[/time],end[/time]]]
DESCRIPTION
The TZ environment variable tells functions such as the ctime(3) family and programs like date what the time zone and daylight saving rule
is. The value of TZ has the POSIX standardized form shown in the synopsis. This form specifies the zone names, offsets from GMT, and day-
light savings changeover times for at least the current year.
zone A three or more letter name for the time zone in normal (winter) time.
[-]offset
A signed time telling the offset of the time zone westwards from Greenwich. The time has the form hh[:mm[:ss]] with a one of two
digit hour, and optional two digit minutes and seconds.
dst The name of the time zone when daylight savings is in effect. It may be followed by an offset telling how big the clock correction
is other than the default of 1 hour.
start/time,end/time
Specifies the start and end of the daylight savings period. The start and end fields indicate on what day the changeover occurs.
They must be in one of the following formats:
Jn The Julian day n (1 <= n <= 365) ignoring leap days, i.e. there is no February 29.
n The zero-based Julian day (0 <= n <= 365). Leap days are not ignored.
Mm.n.d
This indicates month m, the n-th occurrence of day d (1 <= m <= 12, 1 <= n <= 5, 0 <= d <= 6, 0=Sunday). The 5-th occurrence
means the last occurrence of that day in a month. So M4.1.0 is the first Sunday in April, M9.5.0 is the last Sunday in Septem-
ber.
The time field indicates the time the changeover occurs on the given day.
EXAMPLES
Greenwich Mean Time:
TZ=GMT0
Middle European Time, 1 hour east from Greenwich, daylight savings starts on the last Sunday in March at 2 AM and ends on the last Sunday
in October at 3 AM:
TZ='MET-1MET DST,M3.5.0/2,M10.5.0/3'
British time, daylight savings starts and ends at the same moment as MET, but in an earlier time zone:
TZ=GMT0BST,M3.5.0/1,M10.5.0/2
The eastern european time zones also have the changeovers at the same absolute time as British time and MET.
U.S. Eastern Standard Time, 5 hours west from Greenwich, daylight savings starts on the first Sunday in April at 2 AM and ends on the last
Sunday in October at 2 AM:
TZ=EST5EDT,M4.1.0/2,M10.5.0/2
It shouldn't surprise you that daylight savings in New Zealand is observed in the months opposite from the previous examples. It starts on
the first Sunday in October at 2 AM and ends on the third Sunday in March at 3 AM:
TZ=NZST-12NZDT,M10.1.0/2,M3.3.0/3
SEE ALSO
readclock(8), date(1).
BUGS
You may have noticed that many fields are optional. Do no omit them, because the defaults are bogus. If you need daylight savings then
fully specify the changeovers.
West is negative, east is positive, ask any sailor.
AUTHOR
Kees J. Bot (kjb@cs.vu.nl)
TZ(5)
